Blocked Process Threshold

The blocked process threshold in SQL Server is a server configuration option that specifies the threshold, in seconds, at which blocked process reports are generated. These reports provide information about tasks that are being blocked by other tasks.

Suggested Action

The recommended setting for this option is 20 seconds. This means that if a task is blocked for 20 seconds or longer, a blocked process report will be generated. Setting this value too low can cause excessive reporting and decreased performance.

How To Change the Blocked Process Threshold

EXEC sys.sp_configure @configname = N'show advanced options',
                      @configvalue = N'1';
RECONFIGURE;
GO
EXEC sp_configure 'blocked process threshold', 20;
RECONFIGURE WITH OVERRIDE;
GO
EXEC sys.sp_configure @configname = N'show advanced options',
                      @configvalue = N'0';
RECONFIGURE;
GO

Further Reading

​Increase or Disable Blocked Process Threshold | Microsoft Learn

​Blocked Process Threshold Server Configuration Option | Microsoft Learn