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
Server for NMS
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.
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.
..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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.