How many Transaction log files for a Massive db | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How many Transaction log files for a Massive db

Hi 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
http://www.SQL-Server-Performance.Com
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
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx#EHDAE MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
]]>