cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

Raid Configuration

Friends,

I need recomendations from you.Question is that We have 2 servers for Solarwinds(1 is for SQL,1 is for Solarwinds)  but the server is assigned for SQL server has 3  hdd's.What Raid configuration is recommended for SQL DB?

Here is information about these servers:

Server for NMS
PowerEdge R320
Intel® Xeon® E5-2440 2.40GHz, 15M Cache, 7.2GT/s , Turbo, 6C, 95W
3.5" Chassis with up to 4 Hot Plug Hard Drives
On-Board Broadcom 5720 Dual Port 1GBE
Bezel - 4/8 Drive Chassis
RAID C6 - No RAID for H310, 1-4 SAS/SATA/SSD HDDs
(3) 4GB RDIMM, 1333 MHz, Low Volt, Dual Rank, x8
(3) 300GB, SAS 6Gbps, 2.5-in, 10K RPM Hybrid Hard Drive (Hot Plug) in 3.5-in Carrier
DVD+/-RW, SATA, Internal for 4HDD chassis
ReadyRails™ Sliding Rails With Cable Management Arm
Dual Hot Plug Power Supplies 350W
Windows Server 2008 R2 SP1, Standard Edition, English, Incl. 5 CALs, No Media

Server for NMS
PowerEdge R320 - 4200
2.5" Chassis with up to 8 Hot Plug Hard Drives
Intel® Xeon® E5-2440 2.40GHz, 15M Cache, 7.2GT/s , Turbo, 6C, 95W 513178
Performance Optimized :
1333 MHz RDIMMs
4GB RDIMM, 1333 MHz, Low Volt, Dual Rank, x8 :
Windows Server 2008 R2 SP1, Standard Edition, English, Incl. 5 CALs,
DVD Media for Windows Server 2008 R2 SP1, Standard Edition, English
C16A - RAID 1/RAID 5 for H310/H710, 2 + 3-6 SAS/SATA/SSD HDDs
PERC H310 Integrated RAID Controller, Mini-type
300GB, SAS 6Gbps, 2.5-in, 10K RPM Hard Drive (Hot Plug) 
500GB, SATA, 2.5-in, 7.2K RPM Hard Drive (Hot Plug)
Performance BIOS Setting :
Dual Hot Plug Power Supplies 350W
Rack Power Cord, C13 to C14, PDU Style,
iDRAC7 Express
On-Board Broadcom 5720 Dual Port 1GBE
Bezel - 4/8 Drive Chassis
ReadyRails™ Sliding Rails With Cable Management Arm :
3Yr Parts Only Warranty

Labels (1)
0 Kudos
3 Replies
Level 18

I can't emphasize enough the need for your SQL server disks to be configured for RAID 10. We have ~10,000 devices and are running NPM/SAM, and we're seeing upwards of 40,000 read/write operations per second. We've got it on a physical server, 192Gb RAM, 32 processors and the box is still struggling to keep up. ConfIO is telling us clearly that disk is the bottleneck.

Leon Adato | Head Geek
------
"Measure what is measurable,
and make measurable what is not so." - Gallileo

Level 16

If I were building my SQL server again I'd go for:

C + Backup: 4*300GB SAS (RAID5)

Database: 2*300G SSD (Mirrored)

Log: 2*300G SSD (Mirrored)

this would give me 300GB for data and log, plus ~600GB for backups of my SQL data. it would fit in one chassis and I would not need an external disk array. the system disk for sqlserver does not need to be that fast -- once sqlserver is loaded into memory you should not need to swap (that will kill performance).

with three disks the best performance you could get would be to have a single system disk + mirror the other two for the database.

/RjL

Level 17

..but the server is assigned for SQL server has 3  hdd's.

With only three drives you don't really have a lot of choice. Three drives can only be configured as RAID-5, and a single RAID-5 array is a poor choice for a SQL Server.

Also, I would think that the R320-4200 with eight 2.5" bays is a better design for a SQL Server installation than the R320 with four 3.5" bays.

However, at a minimum, I'd say add the fourth drive to the R320 and configure it with RAID10 (which may require a RAID controller upgrade as well).

Optimally, I'd say fully populate the R320-4200 and make that the SQL Server, and leave the R320 with the 3-drive RAID5 for your SolarWinds server (which, with a back-end SQL Server, really is just a web server anyway).

What Raid configuration is recommended for SQL DB?

Ideally, databases should be installed on RAID10 with a minimum of four spindles, transaction logs should be installed on RAID1 (but RAID10 is really helpful), and the OS should be installed on RAID1.