USER DATABASE PFS WAIT

  • Hi All.

    Recently, monitoring our queries through sp_whoIsActive, i'm getting a couple of queries waiting for PageioLatch, but the page that is reported is the PFS Page on the user Database (Screenshot Attached).
    I've searched on posts, but all topics are related to waiting in tempDB , when it comes to PFS wait.

    When the query starts (leaving the suspended state), it runs very fast, and if i look the execution plan + runtime stats (IO and CPU Time), everything looks fine.
    Does anyone knows how to troubleshoot this issue?

    Regards
    Luiz

  • There's a difference between PAGEIOLATCH and PAGELATCH waits

    The info you'd have seen about PFS page waits in tempDB are PAGELATCH waits, waits to access a page that's in memory.
    You have PageIOLatch waits, which are waits for a page to be read from disk into memory, and here the fact that it's a PFS page is pretty irrelevant. You troubleshoot it the same way you do for any other PageIOLatch waits

    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
  • Hi Gail.
    Thanks again for the help!!

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

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