sql memory paging detection?

Question

Post reply

sql memory paging detection?

vsamantha35

SSChampion

Points: 11551
More actions
November 23, 2015 at 12:01 pm

#302451

Hi All,
Is there any easy way to detect SQL Server memory is getting paged out?
My SQL Server Version is:
Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64)
Thank you.
-Sam

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

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

mark.williams 37494 SSCommitted Points: 1661 More actions · Answer 1

My understanding is that SQL doesn't use page files

_________________________________________________________________

"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

If Windows pages SQL's memory out to the page file, there will be a message in the error log. SQL doesn't use the page file itself.

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

vsamantha35 SSChampion Points: 11551 More actions · Answer 3

Okay Thank you. Does sql always logs this message or only whenever large amount of working set trims will get logged in SQL ERRORLOG? Checking if there is any easy way, DMV or so to determine the same.