Red Gate forums :: View topic - Trouble with deadlock object id
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

Trouble with deadlock object id

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ginacresse



Joined: 13 Oct 2011
Posts: 6

PostPosted: Thu Oct 13, 2011 7:35 pm    Post subject: Trouble with deadlock object id Reply with quote

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?
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Fri Oct 14, 2011 9:07 am    Post subject: Reply with quote

Hi,

This forum message anawers 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
Back to top
View user's profile Send private message
ginacresse



Joined: 13 Oct 2011
Posts: 6

PostPosted: Sat Oct 15, 2011 1:04 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group