• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

Multiple transaction Log file or one log file?

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
ali_alannah
Asked:
ali_alannah
3 Solutions
 
Psihawk99Commented:
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
 
Scott PletcherSenior DBACommented:
ONE log file.  There is never any operational advantage to more log file(s), only possible disadvantages.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now