How to force Checkpoint process to occur every 2 minutes

Normally, The recovery interval is default to 0. It means SQL Server dynamically manages how offen a checkpoint occure.

We can force the SQL Server to occur the recovery interval every 2 minutes

sp_configure 'Show Advanced Options',1

sp_configure 'Recovery Interval',2
Reconfigure with Override

sp_configure 'Show Advanced Options',0

No comments:

Post a Comment