Figuring out waiting resources in sysprocesses | SQL Server Performance Forums

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

I think it is file id and page id. Gaurav
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

See this KBA…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

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,
1. DatabaseID<img src=’/community/emoticons/emotion-3.gif’ alt=’:O’ />bjectID<br />2. DatabaseID:FileID<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />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=;en-us;224453>;en-us;224453</a>
Thank you!!!! This is exactly what I was looking for. Chris