January 21, 2010 01:21 PM

Gathering Deadlock Information with Deadlock Graph

Use this event class to get a graphical view or XML file of deadlock problems that could be plaguing your SQL code
Rating: (1)
SQL Server Magazine
InstantDoc ID #103246
Deadlock graph is an event class that first appeared in SQL Server Profiler for SQL Server 2005 and remains essentially unchanged in SQL Server 2008. Because of the many important new features introduced in SQL Server 2005, Deadlock graph didn't get a lot of attention. Consequently, this useful feature isn't as well-known as it should be—which is unfortunate because it makes monitoring and fixing deadlock problems much simpler than it was in earlier versions of SQL Server.

If ...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS