Correlate Lock Timeouts with Statements

I’ve been getting lock timeouts on one of my systems, so I captured the timeouts in a profiler trace. Here, we walk through developing a query to correlate the lock timeouts to the code holding those locks.