Sachin Nandanwar (1/20/2011)
If I decide to set a recovery interval which will in turn affect the point where the checkpoint occurs then will the Lazywriter flush the dirty pages to the disk even though it does NOT feel memory pressure or wait for the checkpoint to occur or will itself flush them if it feels memory pressure ?
The lazy writer runs when there is memory pressure. No memory pressure, no lazy writer
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability