On a production SQL Server 2012 database we are getting some odd locking statistics that I don't understand.
- 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?