Sample Header Ad - 728x90

What is the purpose of indirect checkpoint when the default checkpoint time (when recovery time is 0) does a 1 minute checkpoint?

-1 votes
1 answer
568 views
Indirect checkpoint is performed when the target recovery time is configured. When the value is 0, then it will do checkpoints such that default recovery time is 1 minute. Where as if the value is greater than 0 (recommended value is 60), then SQL server will do indirect checkpoints. I'm trying to understand menaing of indirect checkpoint with an example - Suppose value of 40 is configured, then does it mean that: - SQL server does checkpoint so that recovery time is 40 seconds? Then what is the difference between automatic and indirect checkpoint?
Asked by variable (3590 rep)
Sep 27, 2022, 04:08 PM
Last activity: Sep 28, 2022, 09:23 AM