Friday, October 07, 2011 11:09 PM
I have the following RAID types to choose from 0, 1, 5, and 6.
I think I should do these:
- RAID 1 for all system databases (log) and user databases (log)
- RAID 1 for tempdb (both data and log)
- RAID 5 for all system databases (data) and user databases (data)
Thanks for any suggestions.
BTW, I have not included OS, SQL Server application, page file(s), and backups in this list. They are probably will be on the local single physical drive.
Friday, October 07, 2011 11:22 PMModerator
Use RAID 1 for log files and tempdb. Use RAID 1 for data files. Use separate RAID 1 for the operating system and programs.
A separate drive for backups may be a good idea.
Hope this helps.
Monday, October 10, 2011 6:35 AMModerator
Although RAID is not a part of SQL Server, implementing RAID can directly affect the way SQL Server performs. RAID levels 0, 1, 5 and 10 are typically used with SQL Server.
Data striping (RAID 0) is the RAID configuration with the best performance, but if one disk fails, all the data on the stripe set becomes inaccessible. RAID level 0 doesn't provide redundancy and doesn't protect against disk failure. A common installation technique for relational database management systems is to configure the database on a RAID 0 drive and then put the transaction log on a mirrored drive (RAID 1). In addition, use RAID 1 for operating system and SQL Server application.
If data must be quickly recoverable, consider mirroring the transaction log and putting the database on a RAID 5 disk. RAID 5 provides redundancy of all data on the array.
For more information, you could refer to:
Hope this helps.
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
- Marked As Answer by Stephanie LvModerator Monday, October 17, 2011 9:13 AM
Monday, October 10, 2011 8:23 AM
The best is RAID 10 for data files , you can place probably tempdb as well on that array
RAID (1) Mirroring for LOG files
Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/