To resolve this problem, set the blocked process threshold option to a value of 5 (seconds) or higher, or disable blocked process threshold by setting the value to 0.
Microsoft Windows PowerShell and SQL Server 2005 WMI Providers - Part 2. the blocked process threshold.
At first we have to enable the advanced configuration options.I have 2 Dell T7500 Computers, Each running Windows 7 and SQL Server 2008 R2.
The first step in creating an Extended Event to monitor for database blocking is to set the blocked process threshold on.
© 2018 CrispWP Made with in USA · Proudly powered by WordPress.