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.
| Author |
Topic |
|
jdoering
Starting Member
32 Posts |
 Posted - 2001-10-10 : 16:39:53
|
Preview I am trying to come up with the ideal database configuration for my production database server. The database in development is currently 70MB which is soon scheduled to move to production. The production's server specs are:1)dual processor (1 GHertz a piece)2)3 RAID 5 drives each with 18.6 G3)1 GB of RAMI have read numerous articles on how I should configure filegroups and datafiles vs. Logfiles across physical disks and I am so confused now. If I have RAID5 and 34-36GB of useful space across two physical drives, do I even have to drape filegroups & files accross the disks? Or do I just need to create one blob of a file group, then spread files across the physical disks within the filegroup? Please help! If anyone has any scripts they've used in the past, I would appreciated viewing them.Thanks,Julie  |
|
|
|
|
|
Configuring Datafiles with RAID 5