Post reply

Understanding waitresource coloumn in sysprocesses

  • August 27, 2008 at 2:09 am

    #196934

    Hello

    I hv an entry in waitresource coloumn - 10:5:662388

    Does this correspond to : FileId - Pageid - Rowid(Clustered index) ??

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • August 27, 2008 at 2:26 am

    #863554

    What's in the waitresource column depends on the wait type. I'm going to guess that the wait is for a page latch/page io latch and that this resource is databaseID:FileID: PageID, but I could be wrong.

    What's the wait type?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 27, 2008 at 2:34 am

    #863556

    wait type is pageiolatch_sh....

    Is there any chart to get this depending on the waittype....

    or any logic

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • August 27, 2008 at 2:48 am

    #863560

    Ahmad Osama (8/27/2008)

    wait type is pageiolatch_sh....

    Then it is databaseID : FileID : PageID

    Is there any chart to get this depending on the waittype....

    or any logic

    I've seen one before, I can't remember where. Google for wait_type and you should find something.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 27, 2008 at 3:20 am

    #863576

    thanks...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • August 27, 2008 at 3:36 am

    #863581

    Here is one for SQL Server 2000.

    http://www.sqldev.net/misc/waittypes.htm

    I couldnt find one for 2005 though.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply