Filter
Top Products
CHAPTER 12 Managing System Resources
447
Figure 12-4: Avoid I/O contention
The figure above illustrates how you want to spread access across separate
disks to avoid I/O contention.
To avoid disk bottlenecks, follow these suggestions:
• Keep random disk I/O away from sequential disk I/O.
• Isolate IQ database I/O from I/O for proxy tables in other databases, such
as Adaptive Server Enterprise.
• Place the transaction log and message log on separate disks from the IQ
Store, Catalog Store, and Temporary Store, and from any proxy databases
such Adaptive Server Enterprise.
Working space for inserting, deleting, and synchronizing
When you insert or delete data, and when you synchronize join indexes,
Adaptive Server IQ needs some working space in the IQ Store. This space is
reclaimed for other purposes when the transaction that needs it commits.