RAID configuration question for MS GP.
Hi,
I have read many postings about MS SQL server raid configuration but I am getting many recommended solutions so I thought I post the question here.
First off, the server is a DELL T710 with 24gb of RAM and 8 300gb hard drives and we are rolling out a new SQL Server 2008 for our new ERP system (MS Great Plains) which will be accessed by 40-50 users.
According to Microsoft the following setup is recommended:
RAID1: O/S & applications
RAID1: SQL Database log files
RAID5: SQL Data files
After reading some of the postings, most recommended RAID10 so I assume the setup will be as follow (please correct me if I am wrong):
RAID1: O/S & applications
RAID1: SQL Database log files
RAID10: SQL Data files
Now to add a little twist to this, I was speaking to a DELL specialist about a different system configuration. We were thinking about going with a high availability system but did not because it's too costly. The setup is still similar in a sense that there will be a storage array that can meet the required recommended configuration above but he said to me that was the old way of configuring it. The new way and more common these days is to just do one big Raid10 for everything so I am more confused at this point.
Hopefully, you can shed some light and let me know what you think is best from your experience considering good failover, speed and of course ease of restoration (disaster recovery, we use Acronis).
Thank you,
Wayne
I have read many postings about MS SQL server raid configuration but I am getting many recommended solutions so I thought I post the question here.
First off, the server is a DELL T710 with 24gb of RAM and 8 300gb hard drives and we are rolling out a new SQL Server 2008 for our new ERP system (MS Great Plains) which will be accessed by 40-50 users.
According to Microsoft the following setup is recommended:
RAID1: O/S & applications
RAID1: SQL Database log files
RAID5: SQL Data files
After reading some of the postings, most recommended RAID10 so I assume the setup will be as follow (please correct me if I am wrong):
RAID1: O/S & applications
RAID1: SQL Database log files
RAID10: SQL Data files
Now to add a little twist to this, I was speaking to a DELL specialist about a different system configuration. We were thinking about going with a high availability system but did not because it's too costly. The setup is still similar in a sense that there will be a storage array that can meet the required recommended configuration above but he said to me that was the old way of configuring it. The new way and more common these days is to just do one big Raid10 for everything so I am more confused at this point.
Hopefully, you can shed some light and let me know what you think is best from your experience considering good failover, speed and of course ease of restoration (disaster recovery, we use Acronis).
Thank you,
Wayne
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SQL Server works well with the default RAID stripe size as the SQL page files are 8k and the extents are 64k
ASKER
Thanks again for your help guys.
ASKER
Thank you for your quick response. I will go:
RAID1: O/S & applications
RAID1: SQL Database log files
RAID10: SQL Data files
Where can I find or can you recommned the optimal stripe size for each of the above?
Thank you,
Wayne