new SQL server 2012 and Raid Sets

Hi Experts,

I want to buy new SQL servers.
I want to isolate the data with different raid sets.

Which Raid is recommended when I go for SQL2012 or 2014 ?

I want to separate :

OS
DATA Files
LOG Files
TEMPDB
Backup

Which has the best perfomance ?
Eprs_AdminSystem ArchitectAsked:
Who is Participating?
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.

ste5anSenior DeveloperCommented:
To separate those on different volumes on different spindles make sense.

Which has the best perfomance ?

This depends on your requirements and the number of disks you can afford. Here's an short overview: RAID Levels and SQL Server.

The important point is: Do you want redundancy (RAID 5/6EE) or performance (RAID 1+0)?

Depeding on your load and the processor architecture (NUMA or not, numbers of physical cores), a hugh performance boost can be achieved by organizing tempdb correctly (SSD's instead of disks, multiple file groups per phys. core).
0
Eprs_AdminSystem ArchitectAuthor Commented:
Hi,
I want perfomance and with RAID10 I also have redundancy, when I configure my monitoring.
0
ste5anSenior DeveloperCommented:
Just keep in mind, that RAID 10 means to mirror one strip-set to  a second one or more. The number of disks which may be defect at a time, but still have a working raid is [number of mirrors] - 1. So using 8 disks you have to possible balanced RAID10 configurations:

1. 2 mirrors of each 4 disks
2. 4 mirrors of each 2 disks

In the first case only one drive may fail. An further failing drive may be on the second mirror and lead to a failed RAID. Thus you have 1:8.
In the second case three drives may fail. This still leaves one mirror intact. Thus we have a ratio of 3:8.  

So redundancy depends on the configuration.

But those two configrations will have a different performance. But this is a kind of stocastical consideration depeding on some hardware factors of the system (block size, number of controllers, write cache, etc.) which also needs some testing with the actual hardware. The background is quite simple, a write or read is completed, when one mirror has completed this operation. Thus normally having more disks per mirror means better performance. But as already said, this depends strongly on some HW facts.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Eprs_AdminSystem ArchitectAuthor Commented:
I plan with this Raid configuration for my SQL Server:

Each Raid set is physically separated.

OS - Raid 1 with SATA 15k disks
DATA - RAID 10 with SATA 15k disks
LOGS - RAID 10 with SATA 15k disks
TEMPDB - RAID 1 with SSD´s
BACKUP -RAID 1 with SATA 15k disks
0
ste5anSenior DeveloperCommented:
That's basically ok, when it fits into your budget and the anticipated workload.

OS: Remember that per default SQL Server installs master, msdb and also model on OS.
DATA/LOG: depends on the recovery mode. LOG needs to be fast. Save only when you run in full recovery mode.
TEMPDB: SSD's are fine.
BACKUP: Depending on the size of the data and the recovery mode (aka number of necessary full backups) having it fast is also important.
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
Eprs_AdminSystem ArchitectAuthor Commented:
ok then I can ask for some quotes from different vendors.
0
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
Microsoft SQL Server 2008

From novice to tech pro — start learning today.