Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE

• DanielP

  SSCrazy

  Points: 2326

  More actions

  February 27, 2026 at 2:39 am

  #4741202

  Hello,

  Is there a way in Azure SQL Database to change the 'Blocking Process Threshold' like you can do in SQL Managed Instance?

  I tried but couldn't find anything that works.  sp_configure is not supported.  It seems to have a default of 20 or 30 seconds before logging a 'block'.  Wanted to change it to 5 seconds.

  Thanks,

   

  Daniel