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
Last activity: Sep 28, 2022, 09:23 AM