MAX_DISPATCH_LATENCY in extended event , is not clearly explained in msdn.

• rajemessage 14195

  Hall of Fame

  Points: 3346

  More actions

  December 10, 2025 at 10:48 am

  #4698318

  hi,

   

  i have checked reducing it increasing it but could not get any thing, pls explain what exactly it means.

  DROP EVENT SESSION [CaptureSlowQueries] ON SERVER

  go

  CREATE EVENT SESSION [CaptureSlowQueries] ON SERVER

  ADD EVENT sqlserver.sp_statement_completed(

  ACTION(sqlserver.database_id,sqlserver.sql_text)

  WHERE ([duration]>(15000000))),

  ADD EVENT sqlserver.sql_statement_completed(SET collect_statement=(1)

  ACTION(sqlserver.client_app_name,sqlserver.database_id,sqlserver.sql_text)

  WHERE ([duration]>(15000000) ))

  ADD TARGET package0.event_file(SET filename=N'SlowQueries',max_file_size=(5),max_rollover_files=(2))

  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=OFF,STARTUP_STATE=ON)

  GO

  ALTER EVENT SESSION [CaptureSlowQueries] ON SERVER STATE = START;

  add this in sqlhealth