CHECKPOINT
-
Is it important if your database is set as "Truncate log on checkpoint". what is i want to set a checkpoint every let say.... 30 sec? any is it possible to make a job schedule that only has a CHECKPOINT script or are there any way of using CHECKPOINT in every 30 sec? can anyone enlighten me thanks a lot
Lester A. Policarpio
"-=Still Learning=-"
Lester Policarpio
-
If you want to be able to perform a point in time recovery, you NEED your database to be in bulk- or full recovery mode !
Having your db in simple mode (truncate log on checkpoint) means you'll only be able to perform full restores and add differential backup.
SQLServer manages checkpoint frequency itself. There should be no need to schedule checkpoints yourself.
A checkpoint is a system command and defers to a commit.
During a checkpoint all data is forced to be writen from memory to disk. Writing is normaly performd by lazy writes, also managed by sqlserver itself.
Determine your backup strategy ! Check BOL for more info.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
How frequent does this CHECKPOINT occur?
"-=Still Learning=-"
Lester Policarpio
-
Since SQLServer manages that frequency itself, there is no exact number.
Search Books Online for Checkpoint info.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Thanks ALZDBA ur a great help two thumbs up
"-=Still Learning=-"
Lester Policarpio
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply