SQL Server Performance Forum – Threads Archive
Figuring out waiting resources in sysprocesses
I know I read it somewhere, but I also know I had a b**** of a time finding it, so I thought I’d ask here before starting searching again.When I have a waittype, and a waitresource, what are the values in the wait resource?
ie x:y:zzzzz
I know that x is the database id, but I cant remember or find what other 2 are. I think one is a page, but help!!!! Thanks
chris
I think it is file id and page id. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
See this KBAhttp://support.microsoft.com/defaul…port/kb/articles/Q244/4/55.ASP&NoWebContent=1 is any help. As BOL reprents its a Textual representation of a lock resource.
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Thanks. I’ve seen that article Satya and actually keep a printed copy around, but now I want to find out specifically which resource.
File Id and page Id sound right Gaurav. I just need to figure them out. I read an article on it once, how to make your way through and find exactly what is being waited on. Locks are so much easier to figure out than waits. And of course physical IO waits, are a bit obvious. The one that was giving me grief yesterday 0x411, page latch ex. The MS support article syas to check BOL for latching, which I did, but didnt get any further. If I find the information again, I’ll post it here. I’m sure it comes up on occaision for most of us. thanks,
chris
1. DatabaseID<img src=’/community/emoticons/emotion-3.gif’ alt=’:O’ />bjectID<br />2. DatabaseID:FileID<img src=’/community/emoticons/emotion-4.gif’ alt=’
‘ />ageID<br />3. DatabaseID<img src=’/community/emoticons/emotion-3.gif’ alt=’:O’ />bjectID:IndexID (hash value for index key)<br /><br />See:<a target="_blank" href=http://support.microsoft.com/default.aspx?scid=kb;en-us;224453>http://support.microsoft.com/default.aspx?scid=kb;en-us;224453</a>
Thank you!!!! This is exactly what I was looking for. Chris
]]>