March 29, 2011 at 12:41 pm
I'm seeing a waitresource of "OBJECT: 39:2000726180:15" in a blocked process report. I know that 39 is the DB_ID and 2000726180 is the OBJECT_ID. But what is 15 here? This doesn't seem to be documented by Microsoft. I confirmed that for OBJECT, this does NOT correspond to an index_id. The highest indid in sysindexes is 7.
Does anyone know what that last number is for?
Thanks!!
March 29, 2011 at 1:56 pm
It depends on the object. For example a heap table can have four, DatabaseID:FileID;PageID:Slot (or row). So, what kind of object are you looking at?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 29, 2011 at 2:00 pm
Hmm, interesting. The object is a table (non-heap). There is a clustered index and 4 non-clustered indexes. Do you know of a more in-depth explanation of the waitresource values, other than the one at http://support.microsoft.com/kb/224453?
Thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply