SQL Server Performance Forum – Threads Archive

Raid System

Hello, What’s the best Raid Level to use in production server? I am looking for performance and data protection. Cost is not an issue.
ALSO
What would be an ideal way to split the Database, Paging file and log files onto the local drives?
ALSO
How many types of joins does SQL Server support?
Thanks in advance.
California

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…
MohammedU.
Moderator
SQL-Server-Performance.com

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,
California

This tutorial will help you understand the fundamentals. http://www.acnc.com/raid.html Roji. P. Thomas
SQL Server MVP
http://toponewithties.blogspot.com

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
http://www.SQL-Server-Performance.Com
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
http://www.databasejournal.com/features/mssql/article.php/1460091
AKTHAR

Check: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=16995 Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>