SQL Server Performance Forum – Threads Archive
Sysprocess Wait TypesWhen 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=’‘ />
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
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
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=’‘ />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=http://support.microsoft.com/kb/224453>http://support.microsoft.com/kb/224453</a><br /<a target="_blank" href=http://support.microsoft.com/kb/822101>http://support.microsoft.com/kb/822101</a><br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided â€œAS ISâ€ with no warranties for accuracy.<br />
Thank you for the answers!