Red Gate forums :: View topic - what does this lock detail information mean?
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

what does this lock detail information mean?

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



Joined: 28 Feb 2007
Posts: 113

PostPosted: Tue Nov 29, 2011 5:38 pm    Post subject: what does this lock detail information mean? Reply with quote

I'm trying to figure out something about a deadlock in the monitor.

143 Victim process dbid: 5, object id: 72057594746634240, index id: (c4006323692b) EXECUTE Line #: 0
180 dbid: 5, object id: 72057594746634240, index id: (c4006323692b) UPDATE Line #: 1
282 dbid: 5, object id: 72057594746634240, index id: (c700d481e951) UPDATE Line #: 1

Under the lock details, I am seeing this information.
I understand the dbid, and know what database that is. What table do I query for the object id 72057594746634240?
It is not in sys.databases, and not in sys.objects. I'm not even sure what object type it is.
Is this maybe the ID of the lock itself?

I ask because highlighting each item gives me a different object id for each line in the SQL Query fragment.

Next question, just exactly how do I determine what index c4006323692b is for example? That really isn't an
index_id from sys.indexes. So, what might it be?

This also might constitute a new feature request... that being, making the monitor more useful would be to interpret
these lines into just exactly what is being conveyed (i.e., swap names for id's). For example, I know from experience
dbid 5 is a database called 'service'. It would be far more useful if I knew what databases, tables, or other objects
(including indexes) are involved, instead of having to get back into SQL Server and look this information up.

Tia

randy
_________________
What we do in life echoes in eternity <><
Randy Volters
Back to top
View user's profile Send private message Send e-mail
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Tue Nov 29, 2011 5:52 pm    Post subject: Reply with quote

Hi Randy,

This forum message should help. Thanks for your feedback too. We are tracking this feature request also.

Thanks,
Priya
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