Checkpoint in SQL Server

Source: Internet
Author: User
Tags flush

As mentioned earlier, recovery interval can control how much of the modified data SQL Server retains in memory. In fact, we have a question not to say.

That is, the modified data in memory is written back to disk, which means that the data version on the disk and the data operation in the log are synchronized. Of course it means that if the system crashes this time, SQL Server does not need to be restored.

But if it does collapse at this time, how does SQL Server know that the data for these log operations has been written to disk, so SQL Server has a concept.

The concept is checkpoint.

When SQL Server writes some modified data (called dirty data) back to disk (the term of this operation is flush), SQL Server leaves a tag in the log to indicate that the data before this tag is already written to disk. And this tag is called checkpoint.

So we can say that checkpoint represents a flush operation.

SQL Server triggers the checkpoint in the following cases, which is flush:

SQL Server when the service is stopped normally

The log requires a recovery operation that takes more than recovery interval time

SQL Server has insufficient memory available

When the administrator manually submitted the checkpoint command

More than 70% data in the log file

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.