Nov 4, 2015 at 6:39 PM
Edited Nov 4, 2015 at 6:42 PM
The HTML rendered description of the SQL Server Lock Timeout/sec in the SQL Server 2012 template is: Number of lock requests that timed out.
This does not include requests for NOWAIT locks
. A value greater than zero might indicate that user queries are not completing.
However, the counter description is: Number of lock requests that timed out.
This includes requests for NOWAIT locks.
This is confusing for people that put faith of their SQL database on PAL analysis and that trust the html rendered description.
Should'nt the template use the counter SQLLockTimeouts (timeout >0/sec) instead?
see full image at: