Home |
Previous Page | Next Page Monitoring Database Server Performance >
Not all performance problems are database server problems.
This section describes some performance problems related to other
factors in your system:
- When
performance problems are associated with backup operations, examine
the transfer rates for tape drives. You might decide to change table
layout or fragmentation to reduce the effect of backup operations.
For information about disk layout and table fragmentation, refer
to Planning Storage Spaces to Support Fragmentation Schemes.
- For client/server configurations, consider network
performance and availability. Evaluating network performance is
beyond the scope of this manual. For information on how to monitor network
activity and improve network availability, see your network administrator
or refer to the documentation for your network system.
- The coservers that make up the database server communicate through
a high-speed interconnect in massively parallel processor (MPP)
or loosely clustered systems. The interconnect is a potential source
of performance problems. For information, refer to Monitoring Data Flow Between Coservers.
Routine
system-maintenance jobs might conflict with database server use
of the system. If system maintenance jobs are scheduled at regular
times and database server performance declines at those times, you
might suspect such a conflict.
Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]