Troubleshoot Database Performance issues
TIP: Write Rules to watch events
Write rules to watch for events with message IDs:
CCTR138I. Writing rules saves having to look at the IBM® Sterling Control Center
Monitor engine log files to find out when
these messages were logged. This allows you to be proactive on performance issues.
Every 6 hours, a new set of metrics are output that contains valuable database related metrics for that time frame.
TIP: Insufficient Heap memory allocated
Performance of IBM Sterling Control Center Monitor may also be impacted by the amount of heap memory allocated to it. When too little heap memory is allocated to IBM Sterling Control Center Monitor, it can cause the Java garbage collection logic to run more often, which has a negative impact on performance of IBM Sterling Control Center Monitor. The Java Heap Memory Details logged help you ascertain if more memory for the Java heap could help IBM Sterling Control Center Monitor performance. It is advised to not allocate less than 4GB for heap.
Check the metrics data to see how well the database performed in the last 6 hours. Note that the
values displayed are all reset after they’re logged. In the metrics output, time displayed for
inserts and updates for the
CD_STATS_LOG, tables are in
milliseconds and should not be too large. In general, double digit values for these numbers can be
considered as too large.
Control Center Monitor typically inserts multiple rows at a time that is, Control Center Monitor strives for
batch inserts, instead of inserting one row at a time, since batch inserts are more efficient.
TOTAL_EVENTS_INSERTED are the number of
rows inserted for the previous 6 hours, while
TOTAL_EVENT_INSERTS are the number of inserts performed to insert those rows.
TIP: Use Performance gathering and reporting tools
Databases have performance gathering and reporting tools that may be used to help ferret out performance issues. For example, Oracle Automatic Workload Repository (AWR). A database administrator should be able to use such tool(s) to help find, recommend changes, and resolve many problems causing performance issues.