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 […]
Author: Jen McCown
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 […]
2009 Really Knew Where its Towel Was
I've decided to jump on the new year blog post bandwagon. 2009 was one excellent year for MidnightDBA.com, and for the MidnightDBAs. We'll start with me. In 2009, I started blogging on MidnightDBA.com. I got my first SQL 2008 certification, the MCTS in Database Development. My goal is to get MCITP in the next couple […]