Which Raid to Build For My Servers? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Which Raid to Build For My Servers?

Hello Dear friends, I have a question of building Raid for my servers: 1. I have got Dell PowerEdge 610 Server with 6x 300GB SAS Disks (10000 RPM), 8GB Memory, CPU: Intel Xeon E5506, Server Role is (Microsoft SQL Server)
Maximum 50 Users will work with this server (In The future the users will be increased). 2. My Second Dell PowerEdge 410 is equipped with 4x 300 GB SAS Disks (15000 RPM), 4GB memory, CPU: Intel Xeon E5503, Server Role is (File Server)
Maximum 200 User will work with this server (as remote disk They will store Microsoft office, picture, and pdf files). Please advice which raid to configure for each server for best performance and data safety?

Witch percentage of reads and writes you’ll have for each server?

Thank you for your reply, but can’t understood what you mean with the percentage?

The application will write o read more into database?.
Welcome to the forums.
For the first configuration I suggest RAID 1 or 1+0 if the budget allows, as they are expensive and equally good for scalability & performance. http://technet.microsoft.com/en-us/library/cc966534.aspx fyi.
For the second one I suggest RAID5 as you say it is used for a storage purpose with less number of users.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |