BI performance counter: Pages Input/sec

Applies to

Operating System

Description

Similar to Pages/sec except returns the number of read operations on the page file to resolve hard page faults.

If the Pages/sec amount is higher than 1000 this could indicate the server is running low on memory. Page Input/sec and Page Reads/sec are very similar counters, Input/sec is the total number of pages, and Reads/sec is the total number of disk reads to retrieve those pages.

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