Sysprocess Wait Types | SQL Server Performance Forums

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<br />. Can anyone explain ? Any help with any links would be greatly appreciated. <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /> and look at the corresponding text for that resource. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
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 Most probably you would have seen this for wait type PAGEIOLATCH_SH Cheers
Waitresource<br />This field indicates the resource that a SPID is waiting on. The following table lists common waitresource formats and their meaning:<br /><br />Resource Format Example <br />Table DatabaseID<img src=’/community/emoticons/emotion-3.gif’ alt=’:O’ />bjectID TAB: 5:261575970<br />In this case, database ID 5 is the pubs sample database and object ID 261575970 is the titles table. <br />Page DatabaseID:FileID<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />ageID PAG: 5:1:104<br />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. <br />Key DatabaseID<img src=’/community/emoticons/emotion-3.gif’ alt=’:O’ />bjectID:IndexID (Hash value for index key) KEY: 5:261575970:1 (5d0164fb1eac)<br />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. <br /><br /<a target="_blank" href=></a><br /<a target="_blank" href=></a><br /><br /><br />MohammedU.<br />Moderator<br /><br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br />
Thank you for the answers!