Sybase recommends that you distribute data in heavily used databases across multiple disks. To do this effectively, you need to monitor disk usage.
If one or more disks are consistently very busy, distribute the database objects on those disks to other devices. This strategy spreads out the work among disks and allow for greater data throughput.
You can use stored system procedures on Adaptive Server to monitor the disk space:
To determine which devices a specific database is using, run sp_helpdevice or sp_helpdb.
For more information, see sp_helpdevice and sp_helpdb in the Adaptive Server Reference Manual; also see the System Administration Guide.
To check for disk space usage rates and I/O contention, run sp_sysmon.
For more information, see sp_sysmon in the Adaptive Server Reference Manual; see also the Performance and Tuning Guide.
