PerfMon counters have different Page File % Usage values for _Total and C:\pagefile.sys for SQL Server on VM

perfmonsql-server-2008

I am collecting PerfMon counters on a SQL Server 2008 server (which is hosted on a VM), and I am getting different Page File % Usage values for _Total and C:\pagefile.sys. The C:\pagefile.sys values are consistently at zero, and the _Total values are consistently around 26. Other counters (Memory Grants Pending, Page Life Expectancy, Processor Queue Length, Available MBytes) all are showing values indicative of memory and cpu pressure, so I would think that there would be some indication of paging to disk (which the _Total pagefile usage value agrees with but the C:\pagefile.sys instance value does not).

Would anyone have insight into how I should evaluate these two Pagefile % Usage values to determine the actual pagefile usage on the server? Does the fact that the Server is a Virtual Machine have anything to do with why there are two values?

Best Answer

Would anyone have insight into how I should evaluate these two Pagefile % Usage values to determine the actual pagefile usage on the server?

There are a few things that can be happening here, I'll list them in order of likelihood:

  1. You don't have a pagefile at C:\pagefile.sys. It's incredibly rare for there to be absolutely zero usage. You can check the location of your pagefile(s) by running wmic pagefile /format from an elevated command prompt.

  2. You have more than one pagefile and the one on c:\ just isn't getting any use. Still pretty uncommon but possible. Run the command above to verify.

  3. You're reading the Perfmon graph incorrectly. Pretty unlikely, since it's straight forward, but worth mentioning since you didn't post a screenshot of it.

Does the fact that the Server is a Virtual Machine have anything to do with why there are two values?

No.

Related Topic