Archives: March 2013
SQL Server 2012 brings a new feature called Indirect Checkpoint. You can read more about it here: http://msdn.microsoft.com/en-us/library/ms189573.aspx.
With Indirect Checkpoint, you get smaller and too many I/Os
Checkpoint normally writes large blocks of data to disk optimally in single write operation, up to 256KB, depending on the number… Read more
0 comments, 1,339 reads
Posted in Ramesh Meyyappan’s SQL Server Performance Tuning Blog on 19 March 2013