Posted by serge on 05/18/06 16:10

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

• Next in forum: Re: Copying files between servers
• Prev in forum: Re: Need a So-Called SSN Encryption
• Thread view: New server setup and RAID recommendation

[Reply to this message]