Комментарий

• Свойства страницы (1 изменено, 0 добавлено, 0 удалено)

Подробности

Свойства страницы

Содержимое

...	...	@@ -4,26 +4,27 @@
4	4
5	5	{{code language="sql"}}
6	6
7		-DECLARE @key INT = 12
8		-DECLARE @msg NVARCHAR(MAX) = 'L2'
9		-
10		-BEGIN TRAN
11		- IF EXISTS (
12		- SELECT *
13		- FROM DBO.LOG2ENTITY WITH (UPDLOCK, SERIALIZABLE)
14		- WHERE ID = @key
15		- )
16		- BEGIN
17		- UPDATE DBO.LOG2ENTITY
18		- SET
19		- Message = @msg
20		- WHERE ID =@key
21		- END
22		- ELSE
23		- BEGIN
24		- INSERT INTO DBO.LOG2ENTITY (Message)
25		- VALUES (@msg)
26		- END
27		-COMMIT TRAN
	7	+SELECT
	8	+ DB_NAME(er.database_id) AS DB_Name,
	9	+ er.start_time,
	10	+ er.session_id,
	11	+ er.status,
	12	+ er.command,
	13	+ - - performance: er.reads + er.writes AS IO,
	14	+ er.logical_reads,
	15	+ er.cpu_time,
	16	+ er.total_elapsed_time,
	17	+ - - waits: er.blocking_session_id,
	18	+ er.wait_type,
	19	+ er.wait_time,
	20	+ er.wait_resource,
	21	+ - - query: qt.text,
	22	+ qp.query_plan
	23	+FROM
	24	+ sys.dm_exec_requests as er
	25	+ CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) qt
	26	+ CROSS APPLY sys.dm_exec_query_plan(er.plan_handle) qp
	27	+WHERE
	28	+ er.database_id = DB_ID('MyBase')
28	28
29	29	{{/code}}