Monitoring and Graphing user workload

• Overview
• Generating a Workload Graph

Overview

A user workload graph provides a visualization of how particular processes behave over time. Rather than viewing several detailed pieces of information about a particular process, you can graph an aggregate amount of performance information for its intended use.

For example, by using this graph to track increases in user workload on a database server, you can help to determine if there is a problem accessing the database or performing queries in a timely manner.

Generating a Workload Graph

The following example demonstrates how to graph user workload on an Oracle database server.

To generate a user workload graph, complete the following steps:

1. In GlobalScan or My Enterprise, click the name of the server that is running the Oracle database with the user workload you want to chart and click the graphing icon beside the name of the system.
2. Click Workload - User to open the following screen:
   
   

   

3. From the date selector, choose a date and time over which you want to graph user workload.
4. Select one or more users from the list of available users. If you do not see the name of the user for whom you want to generate the graph, click the Update List button.
5. Select one of the following options:
   • CPU % (the percentage of the system's CPU time that is taken up by the processes being run by the user).
   • Memory Size (the amount of the system's page file and virtual memory that is taken up by the processes being run by the user).
   • RSS (Run Set Size: the amount of physical memory being consumed by the processes being run by the user).
6. Click the Generate Graph button.

   A graph will appear. Depending on the date range selected for the graph, this step may take several seconds to a minute to generate. The following image illustrates a CPU % graph with data from the previous month: