question

sudhi avatar image
sudhi asked

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??
deadlock
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Cyborg avatar image
Cyborg answered
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.