August 17, 2004 at 6:36 pm
we just purchased a new dell 2650 to be a Sql server
dual 2.8 xeon
2gb ram
3 - 146gb 10k drives with ROMB,PERC3-DI,128MB
I need to know what would be the best raid setup with the hardware I have.
will be installing sql 2000 and server 2000
Thanks in advance
August 17, 2004 at 7:12 pm
RAID 5 seems the only option.
August 18, 2004 at 8:36 am
Allen is correct. You don't have a lot of options with only 3 drives. How large are your databases?
If I were building this, I'd go ahead and buy an extra 2 x 18 or 36 gig drives as the 2650 will handle 5 drives, correct? You could then mirror these 2 and use them for the OS, SQL Server and the logs, place the data files on the second 3 drive array and make that RAID5. I haven't worked with Dell's alot but I assume that you can configure an on-line spare that could fail over to either drive set. If so, this needs to be the same size as your largest drive in the fail over set and you then have the option of setting up the second array as RAID5 or RAID1 with a hot spare that can fail over to either set.
Regardless, disks are relatively cheap and you'll avoid some headaches down the road by maxing out your drive space now. Just my 2 cents worth. Hope this helps.
My hovercraft is full of eels.
August 19, 2004 at 10:19 am
I'd agree. We had the same server running Windows 2000 Server and SQL Server 2000. Our server was setup for a small (~5GB) database that run a web application. We set up the server like this:
2 x 36gb RAID1 - OS, SQL Server Install, SQL Server Logs
3 x 36gb RAID5 - SQL Server Database files
It worked well for us for a long time. We bought two spare 36gb drives just in case. All 7 drives were exactly the same.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply