waitresource explanation on sysprocesses (sql2000)

Posted on 2007-10-02
Last Modified: 2012-08-13
on sqlserver2000 sp3 I've a problem with a job that hungs, on sysprocesses I find the spid in running with this lastwaittype PAGEIOLATCH_SH and this waitresource 5:3:93291.
The only thing that I can do is kill the spid.
My problem is that I don't know how mean this value (5:3:93291). I understand that the first number is db but what mean the other two numbers and how I can use this value to understand the problem
Question by:ec3008
    1 Comment
    LVL 27

    Accepted Solution


    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:ObjectID      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:PageID      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:ObjectID: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.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now