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

See more

Check out SpotLight, a free, cloud based SQL Server monitoring tool to easily detect, monitor, and solve SQL Server performance problems on any device

 

⇐ Back to index