patternMinor
Lock Timeouts with low Lock Waits
Viewed 0 times
timeoutswaitswithlowlock
Problem
On a production SQL Server 2012 database we are getting some odd locking statistics that I don't understand.
@@lock_timeout is set to -1
How can I have Lock Timeouts without having Lock Waits? I recently added some missing indexes, could that be affecting these numbers?
- Lock Waits/Min: 0.2
- Lock Timeouts/Min: 197.4
- Deadlocks/Min: 0.0
@@lock_timeout is set to -1
How can I have Lock Timeouts without having Lock Waits? I recently added some missing indexes, could that be affecting these numbers?
Solution
It seems you are monitoring a
Most likely the vast majority of the events you are seeing are explained that way. Try monitoring Lock:Timeout (timeout > 0) instead.
Lock Timeouts/sec Performance Monitor counter or perhaps querying sys.dm_os_performance_counters directly. The Lock Timeouts/sec class for Profiler has the following notes in the documentation:Most likely the vast majority of the events you are seeing are explained that way. Try monitoring Lock:Timeout (timeout > 0) instead.
Context
StackExchange Database Administrators Q#27965, answer score: 5
Revisions (0)
No revisions yet.