January 9, 2003 at 6:16 am
Basically about to get server with 6 * 36gb hard drives. What would be the best setup for data + logs with RAID and disk space etc? Have system of about 30 users with mainly read queries. Have huge updates on the system once a week.
January 9, 2003 at 6:33 am
I'd say your options are to put OS on two that are mirrored and use the other four for RAID5, or just put the whole thing on RAID5. Of the two, I like the second plan better, you need the spindles to keep perf up and the OS would still be on a protected system.
Andy
January 9, 2003 at 8:12 am
Thanks for your advice.
So if raid5 the lot have the data and log together? Read various bits and pieces and advise data on raid5, log on raid0 or raid1?
Was thinking 4 drives (36gb) raid 5 for os and data. Then 2 drives (have found I can get 72gb) then raid0 these 2 drives for log.
Know I get problems if log drives go down. But logs have no transactions I can not rebuild (as big updates or inserts done once a week).
January 9, 2003 at 8:44 am
If you can live with your server crashing if one log drive goes bad. I would not put the TLOG on RAID0.
Also if you don't have transactions then why two drives for TLOG. Won't one drive do?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply