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 '12 at 09:01 AM in Default

sudhi gravatar image

10 1 1 1

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

2 answers: sort voted first
more ▼

answered Aug 31 '12 at 09:05 AM

Cyborg gravatar image

10.6k 36 39 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 '12 at 11:14 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
91k 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



Answers and Comments

SQL Server Central

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



asked: Aug 31 '12 at 09:01 AM

Seen: 585 times

Last Updated: Aug 31 '12 at 11:14 AM