Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Check point issue

Author  Topic 

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2011-02-24 : 04:06:04
Hi Experts,

As per my theoretical knowledge whenever we do transaction it will get initially stored in .trn file and later SQl server issues check point to harden it in Data file.
.
On what frequency it will issue a check point ?
How do we check this ?
How to vary this ?

Please help me to understand this.

Thanks,
Gangadhar

Thanks,
Gangadhara MS
SQL Developer and DBA

shishirkhandekar
Starting Member

23 Posts

Posted - 2011-02-24 : 15:47:11
See section "Checkpoints and the Active Portion of the Log" in SQL Server Books Online or http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx?pr=blog

SK
Go to Top of Page
   

- Advertisement -