Hi everyone!
I am trying to use the SQL Server blocked process reporting feature but it is not working. Below the commands I executed and the article I followed.




What am I missing?
Thanks.
Hi everyone!
I am trying to use the SQL Server blocked process reporting feature but it is not working. Below the commands I executed and the article I followed.




What am I missing?
Thanks.
I would change the sp_configure value to 10. It is the deadlock detector that also checks for blocked processes and it wakes up every 5 sec (slightly simplified). Perhaps it is confused by the values 1?
Also,what events do you capture in the trace?
Finally, I dont remember if this configure requires engine restart, so please check that.
Blocked threshold will not report if you set for 1 Sec.
The minimum is 5 sec.
Set above 5 sec and validate the same.
https://blog.sqlauthority.com/2014/06/30/sql-server-find-blocking-using-blocked-process-threshold/
Unfortunately the same result. It simply doesn't register anything. Could it be something else?

Regards.
Hi Doria-6500,
Try below T-SQL again. The setting takes effect immediately without a server stop and restart.
sp_configure 'show advanced options', 1 ;
GO
RECONFIGURE ;
GO
sp_configure 'blocked process threshold', 20 ;
GO
RECONFIGURE ;
GO
Please refer to MS document blocked process threshold Server Configuration Option to get more detail information.
This is a blog talking about this, hope it could help you.
Scripts to use the Blocked Process Report
If the response helped, do "Accept Answer" and up vote it.
Best regards.
Cathy
2 people are following this question.