SQL Server Performance Forum – Threads Archive
New Server SetupHi ,
i am setting up a new server with Windows 2003 Std + SQL 2005 Std. i need some advice.
2 Disk in mirror (OS installed)
3 Disk in Raid 5 I have install SQL Server on the mirroed drives(where the OS is installed) and place the data files on the Raid 5 , FOr performance issue i want to put the log files on the mirroed disk, what do you guys think? Thanks AKTHAR
Hi: <br />its recommended to seperate Sql data and log files for optimum performance. And you are doing/thinking the same.. <br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />] <br /><br />if possible try to have 2 or 3 more disk for following configurations:<br /><br />2 DISK: RAID 1: OS+SQL installation with tempdb +PageFile<br />4 Disk: RAID10: SQL Data (Alternative, 3 Disk: RAID 5: SQL Data)<br />2 Disk: RAID 1: SQL Logs<br /><br /><br /><br /><br /><b>Deepak Kumar</b><br /><font size="1">MVP, MCDBA – SQL Server<br /><br />Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.</font id="size1">
Thanks Deepak AKTHAR
Hi, How many RAID controllers we need for best performance? or just one with above config?
1 is far enought. 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.