SQL Server Performance Forum – Threads Archive
Raid?
Hello! I have searched this forum and couple of sites on the internet for raid configurations. Some sites say OS – Raid 1User DB – Raid 5
Logs – Raid 1 While other says OS – Raid 1
User DB – Raid 10 or 1
Logs – Raid 1 Some says that Raid 5 is slow with 3-4 disks and come to its right first when you get 5+ disks. Another thing. When the setup is OS/UserDB/Logs, where should I place the tempdb? Where should I place the tempdb-log? And maybe most important.. Where can I place the other system databases? I am thinking of two partition on the OS-raid. One for the OS and one for system databases and also the system databases logs. So that the Logs (raid 1) disks can work with the logs of UserDbs only. Comments?
I´m whit 2nd option (User DB Raid 10 or 1).
Now, how many channels do you have?.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
The answer is ‘it depends’ on the database usage and importance of its availability, always keep TEMPDB on a disk where it sits exclusively by seperating log and data files onto seperate disks. Refer to the tips section in this website about RAID levels and SQL Server database settings. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
I am thinking of a setup like this: OS – Raid 1
User DB – Raid 5 (6 disks)
User Logs – Raid 1
System DB and logs – Raid 1 But you (satya) suggest to have the tempdb data files seperated from the tempdb logs? So If I have this setup, should where should I have the tempdb data and where should I have the tempdb logs?
Hm, do not worry much about TEMPDB log as it will be SIMPLE recovery model and leave it on the same drive where tempdb data file is located/. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Thanks!
]]>