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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2004-07-12 : 11:56:47
|
| We run a server with RAID 1 disk mirroring. The two disks support Windows 2000, IIS and SQL 2000.What's the next most cost effective disk arrangement that would provide an expansion in disk performance? I'm thinking it's dual (4 disk drive) configuration: Drive C is RAID 1:1 for programs and log files, Drive D is RAID 1:1 for SQL database and webs? (Maybe webs on drive C)?Sam |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-12 : 13:31:03
|
| This is a hard one if you only have four disks. I would take the arrangement you stated above. Then set up perfmon to capture your physical disk queue lengths and read/writes. Move the webs and possible the paging file between the disks until you get the optimal configuration.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Recommendations for new server