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 |
|
jainfo
Starting Member
1 Post |
 Posted - 2003-05-01 : 21:54:32
|
| I am building a sql2000 database and I have a server with 2 145gb hard drives. The drives have been setup with Raid1(hardware mirroring). The sql database will be accessed by about 50 users daily performing writes mostly. Would it have been better to have more smaller drives than 1 big one drive, for this type of environment. |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2003-05-01 : 22:05:01
|
| A lot of write activity benefits immensley from indepedant disks for log and data. A controller on each is optimal....DavidM"SQL-3 is an abomination.." |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-02 : 00:00:31
|
| RAID 0+1 is optimal. the more spindles the better. RAID 1 is typically not recommended for Data, though it is fine for Log.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
|
|
|
disk configuration I/O