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
GO

sp_configure 'Recovery Interval',2
Reconfigure with Override
GO

sp_configure 'Show Advanced Options',0
GO

No comments:

Post a Comment