Short and simple post – filed under “Joe – you’ve already forgotten about this twice, so write this down somewhere.” Let’s say you have deadlock output that shows the following information for the “clientapp” attribute: clientapp=SQLAgent – TSQL JobStep (Job 0xB813B96C59E6004CA8CD542D8A431A2E : Step 1) Based on this output, we know a SQL Server Agent Job […]
Joe Sack
SQL Server Performance Tuning, High Availability and Disaster Recovery Blog
Finding a Deadlocked SQL Server Agent Job Name
Posted on: January 8, 2014 7:12 am
Tracking isolation level
Posted on: October 26, 2011 7:34 am
When I'm troubleshooting concurrency issues – be it deadlocking or long duration blocks, I’m immediately curious about the isolation level being used. While I may be told that the isolation level is "XYZ", I don’t believe it until I actually see it for myself. There are multiple areas where this information can be retrieved. This post lays […]
