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

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