GilaMonster (10/11/2013)
SQLSACT (10/11/2013)
So, is it safe to say that measuring checkpoint pages/sec is absolutely useless when investigating memory usage and pressure on my SQL Server.No, it's very useful. It's not useful alone, but then very, very few counters are useful alone.
Does that mean that if I have memory pressure, I could possibly see a high checkpoint pages/sec ? Doesn't make sense to me, considering that we have established that checkpoint never actually removes pages from memory.
If anything, I would think that high checkpoint pages/sec would indicate a busy write system.