SQL Workload Analysis displays the number of page faults per second as seen by the SQL Server process; as well as, the server machine instance corresponding to the specific monitored instance.
The Page Faults/sec graph shows a contrast between the SQL Server Page Faults/sec and the Server page Faults/sec, drill-down the graph for a detailed view of a specific time or a specific range of time.
SQL Workload Analysis add-on provides a granular breakdown of wait states with easy drill-down to isolate problems quickly.
|