Monitoring Host Activity

The Host chart on the Performance page displays utilization information about the system hosting the database.

To determine if the host system has enough resources available to run the database, establish appropriate expectations for the amount of CPU, memory, and disk resources that your system should be using. You can then verify that the database is not consuming too many of these resources.

To view details about CPU, memory, and disk utilization:

1. From the Targets menu, select Hosts.

   The Hosts page appears.

2. In the list of hosts, click the name of the host on which your database resides.

   The hostname page appears, where hostname is the name of the host.

3. Determine whether sufficient resources are available and whether your system is using too many resources.

   For example, determine the amount of CPU, memory, and disk resources the database uses in the following scenarios:

   • When your system is idle, or when little database and nondatabase activity exists

   • At average workloads

   • At peak workloads

   Workload is an important factor when evaluating the level of resource utilization for your system. During peak workload hours, 90 percent utilization of a resource, such as a CPU with 10 percent idle and waiting time, can be acceptable. However, if your system shows high utilization at normal workload, then there is no room for additional workload.

   Perform the following tasks to monitor the host activity for your database:

   • Monitoring CPU Utilization

   • Monitoring Memory Utilization

   • Monitoring Disk I/O Utilization

4. Set the appropriate threshold values for the performance metrics so the system can automatically generate alerts when these thresholds are exceeded.

   For information about setting metric thresholds, see "Setting Metric Thresholds for Performance Alerts".