Register | Log In
Download Contact
Resources > Wiki

DotNetNuke Wiki

Home Create a new Page All Pages Tags Search

Analyzing Deadlocks with SQL Server Profiler

Modified on 2011/09/21 04:08 PM by cathal Categorized as debugging, SQL Server
Using SQL Server Profiler, you can create a trace that records, replays, and displays deadlock events for analysis.

To trace deadlock events, add the Deadlock graph event class to a trace. This event class populates the TextData data column in the trace with XML data about the process and objects that are involved in the deadlock. SQL Server Profiler can extract the XML document to a deadlock XML (.xdl) file which you can view later in SQL Server Management Studio. You can configure SQL Server Profiler to extract Deadlock graph events to a single file that contains all Deadlock graph events, or to separate files. The following article shows how to extract the deadlock data from the profiler trace.

This article has a section entitled "A Brief Profiler Primer" that lays this out in further detail. Note: please take care to run traces for a long period of time (typically at least 24hours) and ensure that you are only capturing the deadlock graph class otherwise the trace will impact of server performance.

Once you have a deadlock graph trace you will want to analysis it - the following blogs contain lots of useful information to help with this:

Attend A Webinar
Start Professional Edition Trial
Have Someone Contact Me

Like Us on Facebook Join our Network on LinkedIn Follow DNN Corporate on Twitter Follow DNN on Twitter

Advertisers

Sponsors

DotNetNuke Corporation

DotNetNuke (DNN) provides a suite of solutions that make designing, building and managing feature-rich sites and communities fast, easy and cost-effective. The DotNetNuke Platform CMS is the foundation for more than one million websites worldwide. DNN Social, our newest solution, enables businesses to create immersive, interactive communities. Thousands of organizations like True Value Hardware, Bose, Cornell University, Glacier Water, Dannon, Delphi, USAA, NASCAR, Northern Health and the City of Denver have leveraged DNN to deploy highly engaging business- critical websites. Our rapid growth in product sales and deployments resulted in DotNetNuke Corp. being named one of the fastest growing private companies in America by Inc. Magazine in 2011 and 2012.
Copyright © 2002-2013 DotNetNuke Corp. / Terms of Use / Privacy
Hosted by MaximumASP