How to view a DeadLock
Do the following steps to view a dead lock
- Within a SQL Server connection, right click on 'Blocked Process' and select the 'Blocking' drilldown
- Within this window, click on the 'Playback' icon
- Select the deadlocks in history
- Within this window, click on the 'Deadlock' tab. Highlight the spid and click on 'View plan'.
SSMS will open and display details on both processes.
