Using SQL Profiler to Resolve Deadlocks in SQL Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Jonathan Kehayias » Using SQL Profiler to Resolve Deadlocks in...

47 posts, Page 1 of 5

1 2 3 4 5 »»»

Using SQL Profiler to Resolve Deadlocks in SQL Server

Rate Topic

Display Mode

Topic Options

Author

Message

Jonathan Kehayias

Posted Sunday, February 01, 2009 10:07 PM

SSCommitted

Group: General Forum Members
Last Login: Sunday, May 12, 2013 4:26 PM
Points: 1,696, Visits: 1,742

Comments posted to this topic are about the item Using SQL Profiler to Resolve Deadlocks in SQL Server

Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs

Post #647806

SQL Joker

Posted Monday, February 02, 2009 3:33 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, January 14, 2013 4:54 AM
Points: 835, Visits: 72

Excellent Article. Thank you for the techniques that you shared to track and resolve dead locks.
With very best regards,
Sreeju

Post #647887

Grant Fritchey

Posted Monday, February 02, 2009 6:53 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:41 AM
Points: 13,383, Visits: 25,189

Nice one. Sharp & direct.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #647987

Mike Good

Posted Monday, February 02, 2009 8:48 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 2:09 PM
Points: 265, Visits: 636

Ditto the other comments. This is a superlative article. Thank you.

Post #648084

Jack Corbett

Posted Monday, February 02, 2009 9:29 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

Nice article. Although you just reduced the # articles in the series on profiler I am working on by 1.

Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2

Post #648116

Jonathan Kehayias

Posted Monday, February 02, 2009 9:33 AM

SSCommitted

Group: General Forum Members
Last Login: Sunday, May 12, 2013 4:26 PM
Points: 1,696, Visits: 1,742

Sorry bout that Jack. I am sure that you could add to the basics that are covered by this article though. I tried to follow KISS for this introduction and then I write a few other articles that cover deadlocks from other angles as well. More to come.....

Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs

Post #648124

Jack Corbett

Posted Monday, February 02, 2009 9:49 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

Mine was gonna be pretty much the same. It's my own fault for not buckling down and getting it done. There is still plenty to cover in Profiler and SQL Trace.

Post #648143

TheSQLGuru

Posted Monday, February 02, 2009 12:46 PM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 2:30 PM
Points: 3,582, Visits: 5,131

I think any discussion on deadlock troubleshooting should reference this blog series: http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail

Post #648309

Jonathan Kehayias

Posted Monday, February 02, 2009 12:54 PM

SSCommitted

Group: General Forum Members
Last Login: Sunday, May 12, 2013 4:26 PM
Points: 1,696, Visits: 1,742

There is actually more than just that link:

http://blogs.msdn.com/bartd/archive/tags/SQL+Deadlocks/default.aspx

Bart Duncan has a bunch of them and the above reference is on another article I put in, but I guess I missed adding it to this one.

Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs

Post #648317

SQLBOT

Posted Monday, February 02, 2009 1:21 PM

SSChasing Mays

Group: General Forum Members
Last Login: Monday, February 18, 2013 3:22 PM
Points: 626, Visits: 835

Took me a minute to overcome the 'owner' and 'request' jargon in the deadlock graph.
To me they're all locks and blocks.

So an 'owner' arrow could by paraphrased as 'blocked by', and the request arrow is just the lock request?

Rolleyes

I'm spoiled with some nice 3rd party tools, but the profiler deadlock graph looks like something I can use.
Thanks for the great article.

~BOT

Craig Outcalt

Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258

Post #648343

« Prev Topic | Next Topic »

47 posts, Page 1 of 5

1 2 3 4 5 »»»

Permissions