Advertisement
Guest User

Untitled

a guest
Dec 18th, 2014
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. CREATE EVENT SESSION [Simple Query Benchmarking] ON SERVER
  2. ADD EVENT sqlserver.sql_batch_completed(SET collect_batch_text=(1)
  3. ACTION(sqlserver.query_hash,sqlserver.query_plan_hash,sqlserver.sql_text)
  4. WHERE ([package0].[equal_boolean]([sqlserver].[is_system],(0)) AND [package0].[greater_than_uint64]([duration],(1000))))
  5. ADD TARGET package0.ring_buffer
  6. 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)
  7. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement