I'm monitoring Lock:Timeout value on SQL database for specific table and specific type of lock (lock number 8). I'm seeing a lot of lock acquired/released as well as Lock:Timeout from "sa" account and listed as IsSystem=1.
Why is it happening. How do I catch in profiler specific details related to those locks?
P.S. This is on SQL 2008 x64 SP1.
View Complete Post