BI performance counter: Page File % Usage

Applies to

Operating System


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.

Resolved by


Suggested solutions

  1. Add additional memory
  2. Adjust the Max memory allocation of SQL to remove OS pressure
  3. Determine and address what application/services are impeding on SQL Servers memory allocation
  4. Data page compression if CPU usage doesn’t suffer

Additional research

SQL Shack: Other Memory Metrics
The File Windows Page and SQL Server

⇐ Back to index