This review was written by Sean McCown. Author: Joydip Kanjilal Pages: 256 pages Publisher: Packt Publishing (December 31, 2007) This is one of those books that I wish I could use without reading. What I mean by that is there is absolutely no personality in it at all. It explains the technology, but doesn’t attempt to […]
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 […]