SQL Show (10/11/2013)
A high unusual metric of check point pages /sec may indicate your database need more memory since free pages in memory is required at high rate.
No, because running checkpoint does not free up memory pages.
To solve this requirement of more free pages, database engine may kick check point process too often which results this counter as high.
Checkpoint is not triggered by low free pages. Checkpoint is triggered by the recovery interval and an amount of dirty pages and SQL's estimate of how long recovery would take
You're thinking of the lazywriter.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass