Truncate log on Checkpoint vs. Truncate Transaction Log 
Author Message
 Truncate log on Checkpoint vs. Truncate Transaction Log
I'm importing a largish amount of data (5M+ rows in 25K batches) but
don't care about recovering if an error happens.  I imagine that
specifying the database with the "Truncate Log on Checkpoint" option
would be slower than issuing  "DUMP TRANSACTION WITH TRUNCATE_ONLY" or
NO_LOG.  I know it's splitting hairs, but I'm really trying to reduce
the time on this process.

Any comments?  Thanks.

jon moorman



Tue, 27 Mar 2001 03:00:00 GMT
 Truncate log on Checkpoint vs. Truncate Transaction Log

Truncate on check point happen automatically about every 60 seconds. You can
issue a check point by executing command CHECKPOINT.

The 'dump tran with no_log' is executed manually.

I haven't had 5m rows, my highest was 1m.  I made the log big enough to old
the updates for 60 seconds.  Then I just let the system clean up the log.

Quote:

>I'm importing a largish amount of data (5M+ rows in 25K batches) but
>don't care about recovering if an error happens.  I imagine that
>specifying the database with the "Truncate Log on Checkpoint" option
>would be slower than issuing  "DUMP TRANSACTION WITH TRUNCATE_ONLY" or
>NO_LOG.  I know it's splitting hairs, but I'm really trying to reduce
>the time on this process.

>Any comments?  Thanks.

>jon moorman




Tue, 27 Mar 2001 03:00:00 GMT
 Truncate log on Checkpoint vs. Truncate Transaction Log
Jon,

The "Truncate Log on Checkpoint" option will be easier, and I can't
think of any reason why it would be slower than dumping with
TRUNCATE_ONLY.

Roy



Tue, 27 Mar 2001 03:00:00 GMT
 Truncate log on Checkpoint vs. Truncate Transaction Log
If you are importing using bcp, drop the indexes on the table you are
importing into, set the 'select into/bulk copy'  and 'truncate log on
checkpoint' options for the database, and then do your import.  Remember to
turn those options off when you are done.  The first option will not log
the inserts, only the allocations of additional pages so that less will be
written to the log.

Matthew Bando
Director of Training Services
West Colebrooke Inc.



Fri, 04 May 2001 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Truncate Log without truncate Log on CheckPoint

2. Transaction log backup (NO-)truncate. Why NO truncate

3. truncate transaction log at checkpoint

4. Truncate Transaction Log on Checkpoint

5. Replication vs Truncate log on Checkpoint

6. Replication VS truncate log on checkpoint

7. Replication vs Truncate log on checkpoint

8. checkpoint and truncate log on checkpoint

9. checkpoint and truncate log on checkpoint

10. Recapturing disk space from the transaction log after truncating the log space

11. Truncate Log and Transaction Log Dumps

12. transaction log backups don't truncate the log file...keeps growing


 
Powered by phpBB® Forum Software