Category: Uncategorized

Correlating Data in SQL Trace, Part 1

I’ve been chasing down a series of issues with a system. One of  the symptoms we’ve been getting is massive lock timeouts, so I’ve been taking (server side) profiler traces to see what code is requesting the locks that are being timed out.  Today I landed on a lovely solution for correlating the lock timeouts […]

Lock Timeout Revelation on Twitter

I was all proud of myself today, and bragged a little bit on Twitter about a query I’d written.  That query gets its own blog here shortly, but first, a worthwhile Twitter conversation with Adam Machanic (@AdamMachanic on Twitter, Adam’s blog is on SQLBlog.com) that turned very, very useful: Me: Okay, that cool query from yesterday that correlates lock […]