1
0

QPExtendedEvents.sql 626 B

123456789
  1. CREATE EVENT SESSION [QPDashboard] ON SERVER
  2. ADD EVENT sqlserver.sql_statement_completed(
  3. ACTION(sqlserver.client_app_name,sqlserver.client_hostname,sqlserver.database_name,sqlserver.plan_handle,sqlserver.query_hash,sqlserver.query_plan_hash,sqlserver.session_id,sqlserver.sql_text,sqlserver.username))
  4. ADD TARGET package0.event_file(SET filename=N'QPDashboard.xel')
  5. WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=3 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=OFF,STARTUP_STATE=OFF)
  6. GO
  7. ALTER EVENT SESSION [QPDashboard]
  8. ON SERVER
  9. STATE = start;