sql trace script-白红宇

sql trace script

阅读量：7008 次

发布时间：2019-06-28

本文共 2341 字，大约阅读时间需要 7 分钟。

CREATE EVENT SESSION [sql_query_tracing] ON SERVER

ADD EVENT sqlos.wait_info(

ACTION(sqlos.scheduler_id,sqlserver.client_app_name,sqlserver.client_connection_id,sqlserver.client_hostname,sqlserver.database_id,sqlserver.is_system,sqlserver.nt_username,sqlserver.session_id,sqlserver.sql_text)

WHERE ([package0].[equal_uint64]([sqlserver].[database_id],(29)) AND [package0].[equal_boolean]([sqlserver].[is_system],(0)))),

ADD EVENT sqlserver.rpc_completed(

ACTION(sqlserver.client_app_name,sqlserver.client_connection_id,sqlserver.client_hostname,sqlserver.database_id,sqlserver.is_system,sqlserver.nt_username,sqlserver.plan_handle,sqlserver.query_hash,sqlserver.session_id,sqlserver.sql_text)

WHERE ([package0].[equal_uint64]([sqlserver].[database_id],(29)) AND [package0].[equal_boolean]([sqlserver].[is_system],(0)))),

ADD EVENT sqlserver.rpc_starting(

WHERE ([package0].[equal_uint64]([sqlserver].[database_id],(29)) AND [package0].[equal_boolean]([sqlserver].[is_system],(0)))),

ADD EVENT sqlserver.sql_batch_completed(

WHERE ([package0].[equal_uint64]([sqlserver].[database_id],(29)) AND [package0].[equal_boolean]([sqlserver].[is_system],(0)))),

ADD EVENT sqlserver.sql_batch_starting(

WHERE ([package0].[equal_uint64]([sqlserver].[database_id],(29)) AND [package0].[equal_boolean]([sqlserver].[is_system],(0))))

ADD TARGET package0.event_file(SET filename=N'C:\CTS\wait_info.xel')

WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=ON,STARTUP_STATE=OFF)

转载于:https://www.cnblogs.com/hqbird/p/4056919.html

你可能感兴趣的文章