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!