Returns the paged to disk to resolve hard page faults.
If the amounts are high (above 1000) this could indicate the server is running low on memory. This counter is the sum of Pages Input/sec and Pages Output/sec.
- 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