[dba-SQLServer] Log file reuse

jwcolby jwcolby at colbyconsulting.com
Sat Dec 8 12:04:20 CST 2007


Well, the log file on another drive failed with errors.  No time to
troubleshoot, I am just moving the log back to the same drive. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Saturday, December 08, 2007 11:20 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Log file reuse

If a SQL Server action query completes, does SQL server reuse the now empty
log file?

I have a raid array that is huge and I use to hold these large databases.  I
have another single drive sitting on a SATA channel.  I am experimenting by
placing the log file onto that single SATA drive and the data file on the
raid.  I am running about 660 more action queries to move data from fields
in a 50 million record 680 field wide table to a 3 field wide table.  The
source table and the destination table both sit on the raid, with the log
file out on the non-raid.  I am hoping that because of IO issues, placing
the log file on a different physical drive will speed things up.  I have no
way to really know however.  

I am hoping that once the log file is expanded (it is about 13 g now) that
unless the data in the subsequent fields requires more log file room, the
"cost" of expanding the log file will go away and the log file empty space
will be reused for each subsequent action query.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list