Object ID 99
-
Does any one know what the object ID 99 is?
I am creating a clustered index, that has been going on for 6 hours now and I see it is waiting on a resource, which when I do DBCC Page points to an object 99.. When I look in sysobjects there is no such object. Could this be a temp table used for clustered index?
Thanks.,
-
Slightly of the mark but never the less.
http://manuals.sybase.com/onlinebooks/group-as/asg1200e/aserefmn/@Generic__BookTextView/172152
Search for 99.
quote:
5005extents used
Specifies the number of extents allocated to the object in the partition being checked. For object 99 (allocation pages), this value is the number of extents that are not allocated to a valid object. Object 99 contains the storage that is not allocated to other objects.
BOL 2000:
quote:
500510
Extending database by %.2f MB on disk '%.*ls'.
Did you check the freespace while the process was waiting on a resource
-
Slightly of the mark but never the less.
http://manuals.sybase.com/onlinebooks/group-as/asg1200e/aserefmn/@Generic__BookTextView/172152
Search for 99.
-
Thank you. You are on mark.
It makes sense that when SQL Server is creating a new index, it creates it as object 99, and when finally complete, probably assigns to the table.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply