Page Faults occurs when a program requests an address on a page that is not in the current set of memory resident pages.
Monitoring Page Faults/sec counter shows both had and soft page faults, so it can be difficult to determine whether the page faults value indicates performance problems in SQL Server, and should be addressed, or presents a normal state.
There is no specific Page Faults/sec value that indicates performance problems. Monitoring Page Faults/Sec should provide enough information to create a baseline that will be used to determine normal server performance. The value depends on the type and amount of memory, and the speed of disk access. A sustained or increasing value for Page Faults/sec can indicate insufficient memory.
In SQL Workload Analysis the PAGE FAULTS/Sec graph shows a contrast between the SQL Server Page Faults/sec and the Server page Faults/sec, you can drill-down the graph for a detailed view of a specific time or a specific range of time.
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal