High Number of Lock Requests
-
We're seeing a large number of lock requests / sec on our SQL 2008 db, the current average is ~240,000. They seem to be either key locks or page locks. There's no time-outs, deadlocks and the average wait time is 0. The only other stat that seems high is the context switches, which is around 1k-3k on our 2cpu system. Is this something to be worried about?
-
We're seeing a large number of lock requests / sec on our SQL 2008 db, the current average is ~240,000. They seem to be either key locks or page locks. There's no time-outs, deadlocks and the average wait time is 0. The only other stat that seems high is the context switches, which is around 1k-3k on our 2cpu system. Is this something to be worried about?
cjb110 wrote:
Is this something to be worried about?
Only if you have time to spare. It might hint that additional optimization is possible, but it's not guaranteed that it can be optimized further - it'd be a fun exercise though. You might find this[^] an interesting read to get you started.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]