What are you seeing when you look at the SQLServer:BufferManager Checkpoint pages / sec counter? On the server that I am looking at it is almost continuously writing pages (very bad) whereas on other boxes that I looked at (all 2005) it will write massive amounts and then go silent (expected behavior).
Curious what you are seeing. Thanks in advance.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot