During server operation, the server administrator can use FairCom DB and system monitoring tools to measure performance properties of FairCom DB. The application may also provide tools used to monitor the performance of the system or the database components of the system.
When these system monitoring utilities detect unexpected performance characteristics of the database components of the system, follow these steps to identify the cause of the unexpected performance so the problem can be understood and resolved:
Identify the nature of the unexpected performance characteristics of the system as specifically as possible. For example:
Can specific application operations or FairCom DB function calls made by clients be identified that are performing differently than expected? Application-specific metrics, the ctadmn utility, FairCom DB’s snapshot ability, and the function monitor can be used to identify the specific operations.
Does the system exhibit unexpected system or FairCom DB resource usage patterns (CPU, disk, network usage, etc.) at the time the unexpected performance patterns occur? Use system and FairCom DB utilities to monitor resource usage and compare to normal operation. Differences in resource usage from normal operation may provide insight into the nature of the unexpected performance behavior.
Is the unexpected performance behavior occurring consistently, or does it occur only occasionally? Any pattern that can be identified might help determine the cause of the behavior.
Identify any recent changes to the system that might account for the unexpected performance characteristics. For example:
Has the system load changed (for example are more than the usual number of clients using the server or are the clients performing different different operations than usual)?
Have there been any hardware or software changes (including FairCom DB configuration option changes)?
