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.
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:
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
|