View Single Post

   
  #1 (permalink)  
Old 02-29-2008, 08:25 PM
serge
 
Posts: n/a
Default New server setup and RAID recommendation

I have a database that is around 2 to 4 GB.
If I were to estimate some numbers like 4x growth or
even 10x, the database size could reach 40GB.
The new server will be running SQL Server 2005.

I am not sure which configuration option to take.
I've gathered some information from different places:

Configuration #1:
OS - Raid1 2x36GB
Logs - Raid1 2x36GB
Data - Raid 5 4x73GB


Configuration #2:
OS - Raid1 2x36GB
Logs - Raid5 (not sure how many drives)
Data - Raid5 (not sure how many drives)


Now if I am using a separate RAID array disks
for the database's transaction log, should I also put the
TempDB in this RAID also?

Here's the configuration I am thinking of right now.
Please give me your comments:

OS - Raid1 2x36GB
Logs & TempDB - Raid5 3x36GB = 2x36GB usable space
Data - Raid5 3x73GB = 2x73GB usable space

If you have other configurations you recommend please let
me know.


Thank you


Reply With Quote