Graph Reports

In this section:

Resource Analyzer provides a number of graphs for resource and performance analysis.

To access Graph Reports in the Web Console, click Resource Management on the toolbar and expand the Reports and Resource Analyzer folders. Expand the Graph Reports folder. Right-click the desired report, and select Run from the context menu.

Graph Reports Folder

The eight Graph Reports appear in the tree:


Top of page

x
Cumulative Hourly Use and Peak Transaction/Resource Periods Reports

These graph reports allow you to determine transaction-bottleneck periods for request activity or resource usage by different time periods.

Click a graph report and select Run from the context menu.

The Report Filter window opens.

Report Filter for Cumulative Hourly Use Report

You can filter a report by data source name and/or user name by selecting a valid data source name and/or user name from the drop-down menu, or by selecting ALL, to indicate all data sources and all users. The default is ALL. After you select your data sources or accept the default, click View Report.


Top of page

x
Query Volume vs. Resource Utilization Reports

Un-tuned queries frequently return more data than necessary. Identify the procedures running these requests and target them for optimization.

Right-click Query Volume vs. Resource Utilization, and select Run from the context menu. After specifying report filters, click View Report.The report window opens. This report compares the number of requests to one of four factors of resource usage: CPU seconds, elapsed time in seconds, rows returned, and I/Os (all mapped on the vertical axis). This information is shown for each hour of the day, with the hours mapped along the horizontal axis. The values on the vertical axis are cumulative for the time period of the dates you select for Usage Monitoring data for reports. For more information on setting report date ranges, see Report Filters.

By default, the first graph that appears shows requests graphed against CPU seconds. To view the graph for requests versus one of the other resource factors, select the appropriate option at the top of the screen and click the Draw button. The new graph appears.


WebFOCUS