Solved

new SQL server 2012 and Raid Sets

Posted on 2014-10-21
6
118 Views
Last Modified: 2016-12-08
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 ?
0
Comment
Question by:Eprs_Admin
  • 3
  • 3
6 Comments
 
LVL 33

Assisted Solution

by:ste5an
ste5an earned 500 total points
ID: 40394256
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
 

Author Comment

by:Eprs_Admin
ID: 40394395
Hi,
I want perfomance and with RAID10 I also have redundancy, when I configure my monitoring.
0
 
LVL 33

Assisted Solution

by:ste5an
ste5an earned 500 total points
ID: 40394774
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:Eprs_Admin
ID: 40394811
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
 
LVL 33

Accepted Solution

by:
ste5an earned 500 total points
ID: 40394827
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
 

Author Comment

by:Eprs_Admin
ID: 40406154
ok then I can ask for some quotes from different vendors.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

895 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

16 Experts available now in Live!

Get 1:1 Help Now