• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • 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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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