Feb 25, 2010 | Installation, SQL Server 2005, SQL Server Internals |
I needed to upgrade the underlying IO subsystem of one of my IO intensive SQL Servers. After some discussion with various teams it was decided that the best way to achieve this whilst minimising disruption was to build a fresh server with a new name and a fresh SQL...
Feb 16, 2010 | Recovery, SQL Server Internals, Storage |
What is a SQL Server checkpoint? A SQL Server checkpoint is the process of writing all dirty datafile pages out to disk. A dirty page is page that has changed in memory (buffer cache) since they were read from disk or since the last checkpoint. This is done...
