Back in 2009 Jonathan Kehayias wrote an article on SQL Server Central with the title “Retrieving Deadlock Graphs with SQL Server 2008 Extended Events”. It is a very handy article, it explains how to obtain deadlock information from a SQL Server 2008 or higher version without enabling a trace flag. The only thing I was dissapointed was that you could not save the deadlock graph information as a XDL file and view the graphical representation of the deadlock. I was very happy to findout through a post by Jonathan Kehayias that it is now possible to save the information as a XDL file and open that file with SQL Server 2012 Management Studio.
How to view a deadlock graph using the information from the default SQL Server 2008 system_health session?
Published by
isalom
I was born in Barranquilla, Colombia in 1975. When I was 17 I moved to Curacao where I lived 10 years and then move to The Hague, The Netherlands. I speak 4 languages (Dutch, English, Papiamento and Spanish). I'm a Systems Engineer graduated from The Hague University (http://www.thehagueuniversity.com/). I have been working in IT for over 15 years. Since November 2014 I started www.cenlinea.com a webportal were the focus is to make learning more fun. At Cenlinea we are currently promoting PLAYDIOM a new methodology to learn English. While currently working part-time time at Cenlinea, I am also working as Senior Princiapal Consultant at www.ccgroep.com which helps me to keep up to date with Microsoft SQL Server, which I consider to be one of my favorite things in life as it has changed my life in many ways. I hope you enjoy my blog and if you want to send a question, just drop me a mail at ignacio.salom@cenlinea.com or ignacio@ccgroep.com View all posts by isalom
IgnacioSalom.com 