View Deadlock Graphs

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 Wayne Sheffield » View Deadlock Graphs

View Deadlock Graphs

Rate Topic

Display Mode

Topic Options

Author

Message

WayneS

Posted Sunday, May 03, 2009 3:06 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 10:50 AM
Points: 6,367, Visits: 8,227

Comments posted to this topic are about the item View Deadlock Graphs

Wayne
Microsoft Certified Master: SQL Server 2008

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings

Post #709024

Sam-633226

Posted Thursday, July 23, 2009 9:16 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, February 27, 2010 4:33 PM
Points: 4, Visits: 22

Gettting this error when I run it..

Msg 567, Level 16, State 5, Line 21
File '' either does not exist or is not a recognizable trace file. Or there was an error opening the file.

Post #758327

WayneS

Posted Thursday, July 23, 2009 5:02 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 10:50 AM
Points: 6,367, Visits: 8,227

Hi Sam,

I wrote this script to run along with this one: http://www.sqlservercentral.com/scripts/deadlock/66808/

If you have an active deadlock server-side trace running that has the word "Deadlock" in the output file, then it should work.

Wayne
Microsoft Certified Master: SQL Server 2008

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Post #758703

Sam-633226

Posted Wednesday, July 29, 2009 11:17 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, February 27, 2010 4:33 PM
Points: 4, Visits: 22

Thanks for the update...and yes I was able to pull the graph.
But is there a way to view any external or internal factor is causing deadlocks.
Is it to do with paging what the developers code to fetch the records.
And what is the purpose -EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters

Thanks in advance...

Post #761820

« Prev Topic | Next Topic »

Permissions