Trouble with deadlock object id

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Trouble with deadlock object id

Postby ginacresse » Thu Oct 13, 2011 7:35 pm

We just purchased SQL Monitor and I'm trying to learn how to use it. I'm having trouble identifying the object id for the 'Victor' in a recent deadlock.

Clicking on the Victor process shows this:
RPC Event: Proc [Database Id = 10 Object Id = 170092738]
dbid: 10, object id: 72057595251654656, index id: (1ecb072ce773) DELETE Line #: 469

SQL query fragment:
RPC Event: Proc [Database Id = 10 Object Id = 170092738]

Clicking on the Victim process shows this:
RPC Event: Proc [Database Id = 10 Object Id = 698758588]
Victim process dbid: 10, object id: 72057595236843520, index id: (9539f639141d) SELECT Line #: 24

SQL query fragment:
RPC Event: Proc [Database Id = 10 Object Id = 698758588]

I cannot find object 170092738 when I query sys.objects or sys.all_objects, though I can find the Victim object (it's a stored procedure). How can I determine the object that won this fight?
ginacresse
 
Posts: 6
Joined: Thu Oct 13, 2011 7:10 pm

Postby priyasinha » Fri Oct 14, 2011 9:07 am

Hi,

This forum messageanawers this question.

Regarding the victim object, if you look at the 'Details' tab in Alert Details page then you could view the victim process SPID.

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby ginacresse » Sat Oct 15, 2011 1:04 am

Thank you, Priya. I had looked at that post before, but it seems to be returning information about an index(s). My specific object is a stored procedure (I can tell because of the "DELETE Line #: 469". Why does the Victim object id refer to the correct stored procedure, but the victor object id does not? I have already resolved this particular deadlock on my own, so if you don't have an answer, that is okay. I was just curious.
ginacresse
 
Posts: 6
Joined: Thu Oct 13, 2011 7:10 pm


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests