So yesterday we were researching some deadlocks and decided to produce a deadlock graph in order to have a visual understanding of the situation because pictures are always easier to work with, just ask Einstein. Anyway, we were not able to produce the graph from Profiler because we were doing something crazy, which was filtering on the DatabaseID. Who the hell would ever want to filter on that column in Profiler anyway? So we found that link to Kalen Delaney who posted on the issue over a year ago which means I am only a year behind everyone else on the subject but I figured if I wrote something down about it I might have a chance at remembering it in the future.
That’s a good one. A bit irritating, but a good one.
what is irritating? the bug, or my post?
I prefer this method for deadlock notifications:
http://weblogs.sqlteam.com/mladenp/archive/2008/07/18/Immediate-deadlock-notifications-without-changing-existing-code.aspx