BI performance counter: Page File % Usage

Applies to

Operating System

Description

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

DBAs

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

 

To track BI performance metrics – consider using ApexSQL BI Monitor, a web application that monitors system, SSAS, SSIS and SSRS performance in real time.

⇐ Back to index