O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

blocked process threshold

Type: Advanced

Default value: 0

The blocked process threshold option allows you to specify the threshold, in seconds, at which blocked process reports are generated. By default, no blocked process reports are produced. blocked process threshold uses the deadlock monitor background thread to walk through the list of tasks waiting for a time greater than or multiples of the configured threshold. This option is useful when debugging systems with many deadlock situations. However, there is a cost of overhead involved, so it should be used for only short periods of time.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required