View Deadlock Graphs

Question

Post reply

View Deadlock Graphs

WayneS

SSC Guru

Points: 95460
More actions
May 3, 2009 at 3:06 am

#209081

Comments posted to this topic are about the item View Deadlock Graphs
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
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
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Sam-633226 SSC Enthusiast Points: 144 More actions · Answer 1

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.

WayneS SSC Guru Points: 95460 More actions · Answer 2

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
Author - SQL Server T-SQL Recipes

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
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Sam-633226 SSC Enthusiast Points: 144 More actions · Answer 3

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...

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 4

akljfhnlaflkj

SSC Guru

Points: 76202

May 2, 2016 at 1:06 pm

#1876017

Thanks for the script.

WayneS SSC Guru Points: 95460 More actions · Answer 5

To all: the latest version of this script is up on my blog.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

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
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2