Home > IT Answers > DataCenter > Deciding on configurations for SQL Servers
Help

Question

Asked:
Asked By:
Jul 31 2008   6:10 PM GMT
SQL Server Ask the Experts   2275 pts.

Deciding on configurations for SQL Servers


Servers, RAID, RAID 1 vs RAID 5, RAID 1, RAID 5, SQL Server configuration

My new server has 3 x 146GB SAS 15k 3.5" HD, which came pre-configured as RAID 5, and 2x 73GB SAS 15k 3.5" HD, which came as RAID 1. Should I leave this configuration as is or should I change it?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Aug 1 2008  3:49 PM GMT  by OpenSystemsStorageGuy   545 pts.




That's fairly standard- you'd put the OS on the raid 1 and the database on the raid 5. Ideally you'd have two raids for SQL- one for the data and one for the logs, but if you don't have the spindles for it, you don't have them.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on DataCenter, Storage and SQL Server.

Looking for relevant DataCenter Whitepapers? Visit the SearchDataCenter.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register