SQL Server Performance Forum – Threads Archive
Raid SystemHello, What’s the best Raid Level to use in production server? I am looking for performance and data protection. Cost is not an issue.
What would be an ideal way to split the Database, Paging file and log files onto the local drives?
How many types of joins does SQL Server support?
Thanks in advance.
http://blogs.msdn.com/sqlcat/archive/2005/10/11/479887.aspx Use RAID 10 both for logs and data/index files. When cost is an issue you could allocate data and index files on RAID 5 or equivalent; however, keep logs on RAID 10. RAID 10 offers better availability than RAID 5 and better performance especially for write-intensive applications. Some of our customers have reported up to 50% adverse impact on write intensive work load when moving to RAID 5. The impact on performance of RAID 5 is dependent on the hardware vendor#%92s implementation of RAID 5 and the characteristics of your particular work load. You should not assume that you will get a 50% adverse impact â€“ it could be higher or lower. http://www.sqlskills.com/blogs/kimberly/default.aspx?month=2005-06
Read "8 Steps to better Transaction Log throughput" topic from the above article…
Mohammed, Thanks for your answer. Do you have a side by side comparison between Raid 5 and Raid 10? If no, could you please point to some documentation on this? With your answer, I assume Raid – 10 is the best in terms of Performance and Availability. Am i right? Thanks,
This tutorial will help you understand the fundamentals. http://www.acnc.com/raid.html Roji. P. Thomas
SQL Server MVP
Yes Raid 10 is good for performance, Refer tohttp://msdn2.microsoft.com/en-us/library/ms190764.aspx link too. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Hello, Also a good article
Check: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=16995 Luis Martin
SQL-Server-Performance.com All in Love is Fair
All postings are provided â€œAS ISâ€ with no warranties for accuracy.