SQL Server Performance Forum – Threads Archive

RAID Configuration

In the past I’ve always been given my SQL servers pre-built with one RAID 5 array. Moving forward I’ve decided to implement my arrays as indicated in this his Q&A answer: http://www.sql-server-performance.com/q&a38.asp (RAID 1 OS, RAID 5 or 10 data, RAID 1 logs). My questions are:
1) When installing the "SQL Server binaries" on the RAID 1 array does that include the system databases?
2) Or do you locate the system databases on the RAID5/10 data array?
3) If the latter, how is that accomplished (i.e., during installation or manually after)? Thanks!

Not sure if the answer(s) are the same for 2000 vs. 2005, but in this specific case I am referring to 2005 (sorry if I posted this is the wrong forum). Thanks.

1) By default SQL system databases will be installed in Data directories where the binaries directory is specified.
2) In specific keep TEMPDB on a seperate drive and leave other 3 on the binaries directory.
3) TO change TEMPDB location use:
ALTER DATABASE tempdb
MODIFY FILE(NAME=’tempdev’, FILENAME=’F

ataFiles empdb.mdf’) ALTER DATABASE tempdb
MODIFY FILE(NAME=’tempdev’, FILENAME=’G:LogFiles emplog.ldf’) Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.

Satya, Thank you for your quick reply. I do not have the monies to implement separate arrays for the tempdb data and log files. Are you suggesting, it will still be a performance benefit if I locate them on the "data" array where all MDFs live and the "log" array where all LDFs live? Thanks. Terry

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1180698,00.html
http://blogs.msdn.com/sqlcat/archive/2005/11/21/495440.aspx
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=278154
fyi. HTH Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.

Thanks for the links. While they are informative, I couldn’t find where they help make my decision since they seem to all suggest a separate array for the tempdb, which I will not have. In my scenario:
C: RAID 1 for OS, SQL Binaries, swap file
D: RAID 5 for data files
E: RAID 1 for logs Is it better to leave TEMPDB on C: or move the data file to D: and its log to E: (I think that is what Satya was suggesting in his first reply)? Thanks. Terry

]]>