thanks. I will check the perfromace and the size of log after adding the checkpoint

How do u write it,

Begin tran

Commit tran

checkpoint

if i have 2 begin tran / commot tran then i have to put chekcpoint 2 times?