Hampton Roads SQL Server User Group

February 16, 2022

View Event: What the heck is a checkpoint, and why should I care? An 8K page is the fundamental unit of data storage in SQL Server. For performance reasons, SQL Server performs every data modification operation in memory (buffer pool) and does not write it back to disk immediately. This is where checkpoint comes into […]