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.

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >