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