Post reply

Last Wait Resource 0:0:0 ?

  • June 14, 2016 at 3:17 pm

    #311184

    Hi,

    I'm investigating some strange CPU escalation / sluggishness of our server and noticed a number of Wait types on PAGELATCH_xx whose resource was 0:0:0. Any one familiar with what that might be, is it the sql resources database? I can't seem to dig up anything on it.

    Thanks,

    Scott

  • June 14, 2016 at 3:41 pm

    #1885049

    No page has that ID (resource DB would be 32767:1:XX). Could be referring to an entry in the metadata, but not sure.

    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

  • June 20, 2016 at 11:01 am

    #1885892

    Thanks. I never did figure it out. I was observing this in our SQL Spotlight monitoring tool, I clicked into once and it changed to tempdb.<file> something or other. It may be a tempdb contention type wait or a bug/feature of the monitor

    --

    Scott

Viewing 3 posts - 1 through 2 (of 2 total)

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