x

How to find in profiler ...which store procedures are involved in dead lock

I run the profiler to trace the deadlock, deadlock chain, deadlock graph and store procedure.. Now I got the information from it... But I cant trace the exact store procedures which is cause for deadlock... can U help me about the issue??
more ▼

asked Aug 31, 2012 at 09:01 AM in Default

sudhi gravatar image

sudhi
10 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
more ▼

answered Aug 31, 2012 at 09:05 AM

Cyborg gravatar image

Cyborg
10.6k 36 40 45

(comments are locked)
10|1200 characters needed characters left
Basically you're going to be looking for a particular piece of information. You should easily be able to pick out the queries that were involved in the deadlock from the deadlock graph, yes? The other piece of information you need is the object id. That may be displayed in the deadlock graph visually, but sometimes it isn't. Go to the XML for the deadlock graph. There is an element there called frame. That will usually have the type of query involved and will tell you information about that query. You can usually get the object id there. If not, you can get the sqlhandle there and you can use that in combination with sys.dm_exec_query_plan to track down the object id.
more ▼

answered Aug 31, 2012 at 11:14 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x40

asked: Aug 31, 2012 at 09:01 AM

Seen: 720 times

Last Updated: Aug 31, 2012 at 11:14 AM