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