×

Data Platform Virtual Summit 2022

Date/Time: Friday, September 23, 2022 10:45 to 11:45 EDT
Location: Virtual

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 play. The Database Engine periodically issues a checkpoint on each database. A checkpoint writes the current in-memory modified pages (known as dirty pages) and transaction log information from memory to disk. It also records this information in the transaction log.

This session will explain why you should care and know about the checkpoint process and the different checkpoints that SQL Server does. I will show you exactly what happens during a checkpoint, how you can influence the interval of checkpoints, changes made with checkpoint settings in SQL 2012 and SQL 2016+.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.



profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

RT: @DCACco: https://bit.ly/3QMQ3UF Are you a speaker in the #SQLServer community? Are you going to the #sqlpass ...summit? Time is running out to register for #SpeakerIdol. If you haven't registered already, get registered ASAP. There are only a few days… https://bit.ly/3Smx9VE

Fun, educational, and full of embarrassing stories! If you can make SQL Saturday Boston, then stop by this session for... laughs, groans, and some useful ways to keep the query optimizer working for you!

#SqlSaturday #SqlSatBoston

@SqlrUs will be talking about "Saving Yourself with Accelerated Database Recovery" at #sqlsatboston

Did you register?
...https://www.eventbrite.com/e/sql-saturday-boston-2022-tickets-380639893167

#sqlsaturday #database #sqlserver #ADR #MVPBuzz

@BryanCafferky will be talking about "Python & SQL Server: A Winning Combination" at #sqlsatboston

Did you ...register?
https://www.eventbrite.com/e/sql-saturday-boston-2022-tickets-380639893167

#sqlsaturday #python #SQLServer

@JohnMiner3 will be talking about "Security your delta lake with table access controls" at #sqlsatboston

Did you ...register?
https://www.eventbrite.com/e/sql-saturday-boston-2022-tickets-380639893167

#sqlsaturday #deltalake #security #encryption #MVPBuzz

Load More...