The current percentage of page file in use.
If the Operating System is paging this can be problematic as SQL pages can be pushed into the page file, causing delays for SQL to read what it thinks is in memory from disk. This counter should be as close to zero as possible.
- 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