Page History
...
SQL Server 2005+ includes a new SQL Server Profiler event, the Blocked Process report. This event helps identify blocking issues and provides relevant information to solve these issues. In SQL Diagnostic Manager, you can take advantage of this feature by setting the blocked process threshold value according to your needs. To access the Blocked Process Threshold option, enable Capture Blocking (SQL 2005+) in the Activity Monitor window. Note that when this option is enabled, the blocked process threshold value is automatically set to 30 (seconds) but can be modified as desired.
Since collecting information about blocked processes in SQL server is resource-intensive, IDERA recommends to set the blocked process threshold value to at least 5 (seconds) or your deadlock monitor runs constantly. For more information on this topic, see the Microsoft document Newtablink alias Increase or Disable Blocked Process Threshold. url https://technet.microsoft.com/en-us/library/bb402879.aspx
...