Solved

new SQL server 2012 and Raid Sets

Posted on 2014-10-21
6
119 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL View nearest date 5 36
SQL Server: Unable to remove duplicate sets in Header/Detail 6 23
T-SQL Default value in Select? 5 26
Create snapshot on MSSQL 2012 3 18
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

772 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