Checkpoint interval 값 변경

 

-- 자동 checkpoint 확인

--Issued automatically in the background to meet the upper time limit suggested by the recovery interval server configuration option.

--Automatic checkpoints run to completion.

--Automatic checkpoints are throttled based on the number of outstanding writes and whether the Database Engine detects an increase in write latency above 20 milliseconds.

--For more information, see Configure the recovery interval Server Configuration Option.

- EXEC sp_configure 'recovery interval'

 

 

---- checkpoint 강제로 5분의 interval time을 준다.

---- http://msdn.microsoft.com/en-us/library/ms189573.aspx

--alter database [Test_lock]

--set TARGET_RECOVERY_TIME = 5 MINUTES;

--go