This metric calculates the page fault rate for all processes on the SQL Server computer. The
WMI object Win32_PerfRawData_PerfOS_Memory property
PagesPersec is measured to get this value. For optimal performance, the page fault rate should either be either 0 or very low.
Reduce memory page faults
Use the following solutions to reduce the page fault rate if it rises above 100 for a period of time longer than a momentary spike:
- Decrease the memory being used by stopping unnecessary programs such as the Print Spooler from running on the dedicated SQL Server computer. You should also eliminate activities such as the server acting as a PDC or BDC and (as a last resort) reducing the amount of memory SQL Server may consume.
- Add more physical memory on the computer.
- If the computer is running multiple instances of SQL Server, then consider moving each instance to a separate physical computer.