Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE EVENT SESSION [Simple Query Benchmarking] ON SERVER
- ADD EVENT sqlserver.sql_batch_completed(SET collect_batch_text=(1)
- ACTION(sqlserver.query_hash,sqlserver.query_plan_hash,sqlserver.sql_text)
- WHERE ([package0].[equal_boolean]([sqlserver].[is_system],(0)) AND [package0].[greater_than_uint64]([duration],(1000))))
- ADD TARGET package0.ring_buffer
- WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=1 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=ON,STARTUP_STATE=OFF)
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement