Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

View Deadlock Graphs Expand / Collapse
Author
Message
Posted Sunday, May 3, 2009 3:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:52 PM
Points: 6,581, Visits: 8,858
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
Posted Thursday, July 23, 2009 9:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, July 23, 2009 5:02 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:52 PM
Points: 6,581, Visits: 8,858
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!
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 #758703
Posted Wednesday, July 29, 2009 11:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse