-- 자동 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
'SQL Server 2012' 카테고리의 다른 글
backup database password 옵션 사라졌다~ (sql2012) (0) | 2013.01.16 |
---|---|
sys.dm_db_stats_properties 통계 속성 (0) | 2013.01.07 |
Free ebook (0) | 2012.08.07 |
Resource Governor in SQL Server 2012 (0) | 2012.07.31 |
Memory Manager surface area changes in SQL Server 2012 (0) | 2012.07.12 |