Skip to main content
added [performance-tuning] to 516 questions - Shog9 (Id=1924)
Link
Source Link
J1mmy
  • 530
  • 1
  • 8
  • 21

Page Writes too high but normal values on PLE and BCHR?

Today I was just taking a look on my performance counters and found this...

Average Batch Request per second was 0,6
Average Page Reads per second was 12,5
Average Page Writes per second was ~15000
Average Checkpoint Pages per second was ~15000
Average Page Splits per second was 325

Buffer Cache hit ratio at 99%

Page Life Expectancy at 37256

After searching a bit I found that more than 90 Page Reads and Writes per second could indicate memory pressure but how Page Writes could be an indicator of memory pressure if for example I'm loading data in tables constantly?

Thanks!