×

SQL Friday

Date/Time: Friday, June 03, 2022
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, and changes made with checkpoint settings in SQL 2014 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

I want to talk about forgiveness and why no, white people, you are NOT entitled to it from Black people.

It's been ... around 72 hours since ten innocent people were brutally slaughtered for being Black and as usual when things like this happen, white comfort supersedes Black grief.

My good friend @SqlWorldWide is going to teach us new features SSMS at 6 30 pm EST today..not too late to sign ... up..https://www.meetup.com/tripass/events/285184740/?_xtd=gatlbWFpbF9jbGlja9oAJDQ3ODcxNjg5LTE5Y2EtNDJhYy05N2RiLTNiN2MzZjI0YzdkYg&_af=event&_af_eid=285184740

Happy Monday!! Hope you had a great weekend.

@dgmelkin will be talking about "Choosing the Right Tool for the Job"

... Wednesday May 25, 2022
3 PM EST

Registration:
https://www.meetup.com/dbavug/events/285507807/

#tools #dataplatform #mvpbuzz

I will be speaking at Triangle SQL Server User Group.

New features in Management Studio — Performance Troubleshooting... made easier!

Tuesday, May 17, 2022
6:30 PM to 8:30 PM EDT

Registration:
https://www.meetup.com/tripass/events/285184740/

#ssms #performance #sqlserver #MVPBuzz

Load More...