September 20, 2017 at 2:24 pm
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
September 21, 2017 at 2:07 am
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
September 21, 2017 at 4:33 am
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