Home
Blogs
DBAs@Midnight
Admin
Dev
Midnight Snacks
All Vids
Events
Contact
Links
NTSSUG

Leave a comment.

Name:
Email:
Comment:
(500 chars.)

0 of 500.
What's the picture?



Correlate Lock Timeouts with Statements


Author: Jen McCown
Date: 1/10/2010
Length: 8:24
Size: 20,726 KB

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.

Right-click to download video

Others in Series:

You might also like:

Setup Server-Side Trace
Beginning Execution Plans
Windows Performance Monitoring: Part 1
Uninstall a CU in SQL Server 2008 R2
Interpreting Disk Queues