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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your help!
ASKER
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