Link to home
Start Free TrialLog in
Avatar of langerking
langerking

asked on

RAID 5 vs RAID 10 - How much performance gain

This question has been asked in different ways before, most recently here:
RAID 5 vs RAID 10 in drive array for SQL Server Database   (is the  performance boost really huge with RAID 10?)

https://www.experts-exchange.com/questions/21749401/RAID-5-vs-RAID-10-in-drive-array-for-SQL-Server-Database.html

We are setting up a newSQL Server now with
2 36GB SCSI drives for the OS (mirrored - RAID 1)
4 72GB SCSI drives for Data and Applications  (RAID ????)
The server is a HP ProLiant DL380G4p High Performance Dual 3.4GHz 2GB RAM (we will most likely add RAM, at least 1 GB).  We can't add more drives, there are only 6 bays so the only way to increase capacity later would be to replace the drives with bigger ones.

We were planning to turn the 4 drives into a RAID 5 and then partition this drive into 2 logical drives.  But now I am hearing that for better performance we should use RAID 10?  

My main question is:  is the  performance boost really huge?  

We are a small company (about 100 computer users) with about 50 people accessing the SQL datatbases regularly.  We are expecting a big boost in performance by switching to this new server from a 6 year old server.  Three main SQL based applications on this server:
Microsoft Dynamics Solomon - heavily customized
Goldmine  (CRM package)
Attendance Enterprise (time management system with 4 time clocks, punches primarily early am and around 4 pm - batch processed)
Each of these databases are 2 - 4 GB in size and growing.
ASKER CERTIFIED SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of langerking
langerking

ASKER

What is the best way to measure % of writes?  I have looked at these Performance monitor counters

1.  PhysicalDisk %Disk Time     this was very low all the time
2.  PhysicalDisk Avg. Disk  Bytes/Read     this was very fairly high = spikes to 80%+, but falling in between
3.  PhysicalDisk Avg. Disk  Bytes/Write     this was not as high as 2. = mostly below 40%, spiking higher occasionally

I have looked in SQL 2000 Enterprise Manager and not found any way to capture anything there
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks for your help!