May 3, 2009 at 3:06 am
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
July 23, 2009 at 9:16 am
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.
July 23, 2009 at 5:02 pm
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
July 29, 2009 at 11:17 am
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...
May 2, 2016 at 1:06 pm
Thanks for the script.
May 2, 2016 at 5:37 pm
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
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy