Solved

Multiple transaction Log file or one log file?

Posted on 2013-05-14
3
301 Views
Last Modified: 2013-05-20
Hello
I'm planning move/create an OLTP database that the database is 10 GB and expect to be increased 2 GB every year
My question is related to transaction Log file
which better to create  ONE transaction log file Or multiple Log>  because i read some people said ONE is better for Log .... by the way i have no problem with storage/disk spaces so i can dedicate 100 GB for transaction log on one disk

the other question is what the best RAID level for Transaction log for my database?


Note: Im using SQL server 2012
0
Comment
Question by:ali_alannah
3 Comments
 
LVL 29

Assisted Solution

by:QPR
QPR earned 100 total points
ID: 39163846
0
 
LVL 2

Accepted Solution

by:
Psihawk99 earned 200 total points
ID: 39164969
We have done some research and testing with this.   Multiple transaction logs will not improve performance (though multiple Tempdb files might).   Stick with one file and Raid 1 as stated above.
0
 
LVL 69

Assisted Solution

by:ScottPletcher
ScottPletcher earned 200 total points
ID: 39165116
ONE log file.  There is never any operational advantage to more log file(s), only possible disadvantages.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now