May 6, 2008 at 3:04 pm
Hi,
I'm looking at the waitresource in the sysprocesses as part of index & block troubleshooting (SQL2005)
I see the following value (as an example):
KEY: 12:72057594386382848 (9701bf0d0dea)
I understand it should be in the format (from http://support.microsoft.com/kb/224453):
KEY: DatabaseID:ObjectID:IndexID (Hash value for index key)
I can confirm the '12' in this case is the DB id in question, but what of the remaining number?
Clearly something isn't quite right. Any ideas for determining the index/key in question?
thanks, Mark
May 6, 2008 at 3:22 pm
Looks like a partition ID. Your KB article is SQL 7/2000
Try querying sys.partitions where partition_ID = 72057594386382848
You should be able to get the objectID and index ID from that
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2008 at 10:31 pm
can i able to see the data of key ?
May 7, 2008 at 12:11 am
Should be possible, though I've never tried.
The hex value given (9701bf0d0dea) is a hash of the index keys. If you know what hashing algorithm is used to generate that (maybe a kb article) then you can run th hash on all the index key and see which one matches
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 7, 2008 at 7:02 am
Thanks for your help guys.
I was able to get the indexid from sys.partitions, then the index name from sys.indexes.
Awesome work, much appreciated.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply