disk i/o balancing - response

 I think that you should be breaking up data and indexes separately over as many channels.. Don't break up based on io hits at the system level as you may actually start to degredate your system. It is better to stripe your data over as many disks and channels as possible and then place your indexes on a separate controller and do the same to them. By monitoring for hot files, you should be able to determine what tables are getting hit the most, and if necessary isolate those or stripe them futher.

Sheilah Scheurich
Dimension Systems Inc
DBA My opinions are my own and that of my employer. Received on Fri Feb 07 1997 - 00:00:00 CST