Similar to Pages/sec except returns the number of read operations on the page file to resolve hard page faults.
If the Pages/sec amount is higher than 1000 this could indicate the server is running low on memory. Page Input/sec and Page Reads/sec are very similar counters, Input/sec is the total number of pages, and Reads/sec is the total number of disk reads to retrieve those pages.
- Add additional memory
- Adjust the Max memory allocation of SQL to remove OS pressure
- Determine and address what application/services are impeding on SQL Servers memory allocation
- Data page compression if CPU usage doesn’t suffer
Memory pages/sec and Memory page faults/sec
The Case of the Phantom Hard Page Faults