Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Machine configuration recommendation

Author  Topic 

rubs_65
Posting Yak Master

144 Posts

Posted - 2005-11-14 : 12:34:49
Hi,

We are setting up a new machine with following setup:
Controller1 with 2 1+0 raid array containing 6 and 8 hard disks(logical volumes H and I)
Controller2 with 2 1+0 raid array containing 6 and 8 hard disks and 1 Raid 5 with 3 Hard disks.( Logical volume J, K and L)
Each hard disk is 73GB
I am thinking of following configuration and all recommendation/advice will be appreciated:
Log files on J (Do we have any benefit of creating multiple log files on the same raid array or 1 big size will be ok?)
Tempdb, master and msdb on H
Tables containing maximum data and heavily Inserted/delete/select on I: and their non-clustered indexes and other tables on K
Backup files on L

Thanks
--Harvinder

   

- Advertisement -