• sql trace script


    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(
        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.sql_batch_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.sql_batch_starting(
        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 TARGET package0.event_file(SET filename=N'C:CTSwait_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)
    GO

  • 相关阅读:
    冲刺周期会议三
    冲刺周期会议二
    冲刺周期会议一
    日常会议
    总结会议及站立会议(六)
    站立会议(五)
    站立会议(四)
    【自习任我行】
    软件小创意
    团队项目题目拟定
  • 原文地址:https://www.cnblogs.com/hqbird/p/4056919.html
Copyright © 2020-2023  润新知