b1dupree
asked on
Which RAID is best for SQL Server Performance
Given the choice of one RAID array for a server running Microsoft SQL (either 2005 or 2008) which would you choose?
Thanks,.
Thanks,.
choose any of these , RAID 5 or RAID 10
ASKER
What are the advantages of each?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.
If I use an online spare how many drives minimum would I need for RAID 10?
If I use an SBS Server 2008 running Exchange am I best to go with RAID 5?
If I use an online spare how many drives minimum would I need for RAID 10?
If I use an SBS Server 2008 running Exchange am I best to go with RAID 5?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
RAID 5 is the optimal level for both performance and price and We have the following RAID Levels:
RAID 0, 1, 2, 3, 4, 5, 10
For More info about these levels, refer
http://msdn.microsoft.com/en-us/library/ms190764.aspx
RAID 0, 1, 2, 3, 4, 5, 10
For More info about these levels, refer
http://msdn.microsoft.com/en-us/library/ms190764.aspx
ASKER
brejk:
What's your feeling about numbers of drives for RAID 10 with an online spare?
rrjegan17:
Are you advocating RAID 5 as the best price/performance for SBS with Exchange?
What are your feelings about RAID for SQL?
What's your feeling about numbers of drives for RAID 10 with an online spare?
rrjegan17:
Are you advocating RAID 5 as the best price/performance for SBS with Exchange?
What are your feelings about RAID for SQL?
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.