BI performance counter: Page/sec

Applies to

Operating System

Description

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.

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

Memory pages/sec and Memory page faults/sec
The Case of the Phantom Hard Page Faults

 

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