SQL Server Performance Forum – Threads Archive

Sysprocess Wait Types

When I was querying sysprocesses, I found the following value under wait resource 1:1:126 . Can anyone explain ? Any help with any links would be greatly appreciated. <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />

http://www.sqldev.net/misc/waittypes.htm and look at the corresponding text for that resource. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Please take at his blog also it explains it to some extent http://www.mcse.ms/message600023.html Most probably you would have seen this for wait type PAGEIOLATCH_SH Cheers
Sat

Waitresource This field indicates the resource that a SPID is waiting on. The following table lists common waitresource formats and their meaning: Resource Format Example Table DatabaseID<img src=’/community/emoticons/emotion-3.gif’ alt=’:O’ />bjectID TAB: 5:261575970 In this case, database ID 5 is the pubs sample database and object ID 261575970 is the titles table. Page DatabaseID:FileID<img src=’/community/emoticons/emotion-4.gif’ alt=’

‘ />ageID PAG: 5:1:104 In this case, database ID 5 is pubs, file ID 1 is the primary data file, and page 104 is a page belonging to the titles table. Key DatabaseID<img src=’/community/emoticons/emotion-3.gif’ alt=’:O’ />bjectID:IndexID (Hash value for index key) KEY: 5:261575970:1 (5d0164fb1eac) In this case, database ID 5 is pubs, object ID 261575970 is the titles table, index ID 1 is the clustered index, and the hash value indicates the index key value for the particular row. http://support.microsoft.com/kb/224453</a> http://support.microsoft.com/kb/822101</a> MohammedU. Moderator SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Thank you for the answers!

]]>