How to see deadlocks in SQL Server for Spotlight 8.1.
1. Within a SQL Server connection, right click on ‘Blocked Process’ and select the ‘Blocking’ drilldown
2. Click on the ‘Playback’ icon
3. Select the deadlocks in history
4. Within the next window, click on the ‘Deadlock’ tab. Highlight the spid and click on ‘View plan’.
5. SSMS will open and display details on both processes.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center