SQL Server Performance Forum – Threads Archive
How many Transaction log files for a Massive dbHi Gurus, We have a Production db of 100+GB and it grows at the rate of
20GB in a month. How many transaction log files I must have to get good performance
and to avoid bottlenecks/congession/wait times. What is the best practice for a 100+GB db? Please help Thanks raj
1 is sufficient and 2 is messy.
But you should be able to keep up the log sizes by using frequent log backups or if point in time recovery is not needed then put it in SIMPLE recovery model, don’t forget to perform frequent differential backups in this case. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Log writing is sequential so you don’t get any peformance benifit if you create more than one…
where as you may get performance boost you create multiple data files on different physical disks… http://www.sql-server-performance.com/sql_server_setup.asp
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.