Monthly Archives: January 2012

Blocked SQL Sessions and Blockers

Validated against: SQL Server 2005, 2008, 2008 R2. Below is a SQL script that returns SQL sessions waiting (blocked) for one second or more, and also the associated SQL sessions that are doing the actual blocking. The script returns pretty … Continue reading

Posted in SQL 2005, SQL 2008, SQL 2008 R2 | Tagged | Comments Off on Blocked SQL Sessions and Blockers

Tracking Down a Deadlock Issue.

Validated against: SQL Server 2008 R2. Tracking down the reason for a SQL Server dead lock issue is straight forward enough, simply use the SQL Server Profiler and place a ‘Locks’ trace against the event ‘Deadlock graph’. Start the profiler … Continue reading

Posted in SQL 2008 R2 | Tagged | Comments Off on Tracking Down a Deadlock Issue.