question

kenschwartz avatar image
kenschwartz asked

TAB Resource - index does not exist?

Hi, I am looking at a wait on the following resource: TAB: 46:893298292:7 My understanding is that this was in the format of: TableId: Objectid (which is a table, in this case) : IndexId The first two are returning exactly what I expect. The third is returning an index_id which does not exist for the table in question, as per this query: SELECT * FROM sys.indexes AS ix JOIN sys.objects AS ob ON ob.object_id = ix.object_id WHERE Ob.name = '' any help is appreciated. thanks!
resourceswaits
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
The first ID (46) is the database ID.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.