asked on What raid to choose for OS and Database
We are looking at buying a new database server and I would like to know the best raid setup to use. I have read rad 1 for the os, another raid 1 for the logs and a raid 10 for the database.
Cost is always a concern so to curb costs I will either needs to do 1 raid 5 or 1 raid 10. The OS/Database/ and logs would all be on the chosen raid.
So is 1 raid 10 better than 1 raid 5 with a hotspare?
Thanks,
Cost is always a concern so to curb costs I will either needs to do 1 raid 5 or 1 raid 10. The OS/Database/ and logs would all be on the chosen raid.
So is 1 raid 10 better than 1 raid 5 with a hotspare?
Thanks,
Server HardwareMicrosoft SQL ServerMicrosoft SQL Server 2005
Last Comment
chapmandew
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
P.S. raid 5 is ok for general use - read is pretty good. Write is twice as slow. Raid 5 is also based on striping which can take a while to recover a dead disk - basically has to realign across all disks. Raid 5 is not good for databases.
For your OS, you can use a RAID 5. For where you place your data files and log files, your best bet is to use RAID 10 if you can afford it. It is a lot faster than RAID 5, and is fault tolerant.
Also, you'll want to place your log files and data files in seperate containers if possible, as the log is written to sequentially, and the data files and written to/read from randomly.
Also, you'll want to place your log files and data files in seperate containers if possible, as the log is written to sequentially, and the data files and written to/read from randomly.