Sql Server disk configuration

I have a SQL server that is used for both write and read. I have a host with 8 15K drives and I need to configure the SQL server and the Databases. I have thought of 3 scenarios

Raid 1 for OS, Raid 10 (4disk) for my Data file and Raid 1 logs file
Raid 1 for OS, Raid 10 (6disk) for my Data file and logs file
Raid 10 (8disks) for everything
Any other ideas?
tonzur40Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nitin SontakkeDeveloperCommented:
Being a business application developer, I don't have much understanding in raid configuration. Having said that, one invaluable piece of advice from SQL Server configuration is to separate disks for .mdf (data) and .ldf (log) files is a best practise from performance point of view. This may not fetch much benefit (I guess) if the drives are logical but helpful if they are physical.

Please take this with a spoonful of salt.
1
yo_beeDirector of Information TechnologyCommented:
I like the first layout the best.
It is best practice to separate the OS, DB's and Logs on separate logical drives.
Be that you have 8 disk your first layout is the best for performance and fault tolerance.
Option 2 is not a good practice, but can be done.
Option 3 is pretty much a NO-NO in the setup.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
John TsioumprisSoftware & Systems EngineerCommented:
Some years ago when a server was ordered for SQL the vendor advised this configuration
RAID 1 OS --> 2 Disks
RAID 1 Logs --> 2 Disks
RAID 10 Data --> 4 Disks
I think i have saw a paper that also MS recommended this setup....
2
Acronis Data Cloud 7.8 Enhances Cyber Protection

A closer look at five essential enhancements that benefit end-users and help MSPs take their cloud data protection business further.

David FavorLinux/LXD/WordPress/Hosting SavantCommented:
Go with John Tsioumpris setup suggestion.

I'd likely put the OS + Logs on one disk, as once your OS starts up + loads the OS into memory, your OS disk access should be minimal... well... depending on if you have enough memory to keep from swapping... and have no other disk hog applications running that produce massive i/o thrash on the OS disk.
1
arnoldCommented:
Information missing to say  for sure, size of available drives,
Server specs.
The log files are potentially high I/o placing them in the same spindles as the os where commonly the page file is, when the resources are need for swap, the decline in performance could be in geometric proportions.
Size of databases involved, transaction log sizes can be managed by SQL jobs for transaction log backups on a frequency.

Echo your first indicated option.
0
tonzur40Author Commented:
Thanks a lot I will go with option 1
1
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.