Solved

Multiple transaction Log file or one log file?

Posted on 2013-05-14
3
302 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Minus first query 1 36
Join vs where 2 38
Rename SQL Instance/SQL Developer Edition 2012 2 11
Sql Query with datetime 3 12
Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

896 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

14 Experts available now in Live!

Get 1:1 Help Now