Return
-
Title
How to open deadlock graph files (.xdl) in Spotlight via SQL Server Management Studio -
Description
When receiving deadlock alerts, these alerts come with deadlock graph (.xdl) files. Is there an option to open them up in Spotlgiht via SQL Server Studio Management?
-
Resolution
1. Go to 'Monitor' ribbion and choose 'SQL Activity' (or from the 'Home,' click on 'Blocked Processes' and click on 'Show Me)'
2. Click on the 'Deadlocks'
3. In the 'Deadlocks' tab, click on the 'View graph' ribbion to launch SQL Server Management Studio see the dead lock graph (.xdl)
-
Additional Information
Note: Spotlight only sends the info to SQL Server Mangement Studio and Management Studio does have issues rendering the deadlock graphs. See link: http://connect.microsoft.com/SQLServer/feedback/details/740065/deadlock-graphs-are-not-displayed-in-sql-profiler-or-ssms-when-the-deadlock-includes-a-hobt-lock