Resource Analyzer Reports

In this section:

The following section provides a description of each report in the Resource Analyzer folder.

To access these reports in the Web Console, expand the Resource Analyzer folder in the tree, click the desired report, and select Run.



Usage Analysis Reports

In this section:

Reference:

Usage Analysis reports provide information on reporting activity. To access Usage Analysis reports in the Web Console, expand the Usage Analysis folder in the tree and then expand the appropriate Usage Analysis report folder (Users, Procedures, or Data Sources). Right-click the desired type of usage analysis (Frequency of Use, Resources Used, or Historical Use) and select Run from the context menu.

The following image shows the Usage Analysis and Users report folders expanded.



Reference: Usage Analysis Categories

There are three basic Usage Analysis categories:

  • Users. This category provides a variety of information about the users at your site, such as how many requests each user submits, the dates and resource consumption of those requests, the data sources certain users are accessing the most, and whether they are issuing ad hoc or cataloged requests, summarized or detailed requests, and so on.
  • Procedures. This category gives a variety of information about the remote procedures used to submit requests, including the actual syntax of the requests.
  • Data Sources. This category shows how your data sources are being accessed, what kind of activity patterns are occurring at your site, and the earliest and latest data access dates. These reports show more detailed information, such as aggregate functions used against columns, and column use in relations, sorting, and grouping.


Reference: Types of Usage Analysis

Usage Analysis Reports can measure three types of usage:

  • Frequency of Use. Focuses on how frequently particular data sources are accessed, users make requests, or procedures are executed.
  • Resources Used. Focuses on the resources consumed by requests to particular data sources, by particular users, or with particular procedures.
  • Historical Use. Shows data source, user, and procedure information over time.


Users Reports

In this section:

One of the best techniques for improving system performance is to educate users about request preparation. Education involves familiarizing users with what data is available and what constitutes the designs of different data sources. If users understand what is required of them in executing requests, their expectations about system response will be more realistic. After educating users, you can then organize elements of the data according to user needs, taking into account efficient grouping and clustering of this data. Some questions to consider about users are:

  • Are users familiar with the cardinality of the data sources and the impact of multiple joins?
  • Have the profiles of the users been identified?
  • Who are the novices, who are the experienced users, and what are their habits and performance expectations?
  • Do users visit data very often or sporadically?
  • Are user profiles predictable or do they operate in binary mode, where most of the time they impose no activity on the system but sometimes they consume every computer resource possible?

The Users reports help you analyze the activity of users at your site and determine such information as: whether users are novice or experienced, which data sources they are accessing most often, when they are using the most resources, and so on.



Users Report by Frequency of Use

The following image shows the Users Report by Frequency of Use, which provides a summary of user activity. This report lists users on the left, followed by columns with hyperlinked headings that indicate the number of requests the users submitted, their percentage of total requests and resource usage, and their first and last access dates. Click any of the hyperlinked column headings to re-sort the report by that column.

Users Report by Frequency of Use

This report has several hyperlinks that allow you to drill down to additional reports. The following table lists and describes these hyperlinks.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the User column.

Data Source Use by User

Lists the data sources accessed by the specified user, information about the requests, and dates of access. Also allows you to drill down to see column and data type information, as well as procedures used in requests by the specified user.

A value under the Number Procedures column.

Procedure Summary for User Frequency of Use

Lists the procedures executed by the specified user along with statistics about each execution.

A value under the % Total Requests column.

Procedure Summary for User

Lists the procedures used for requests by the specified user, along with request and resource information and dates of access. Also allows you to drill down to see detailed request information for each procedure as well as the actual request syntax.

A value under the % Total Resources column.

Resources used by User

Summarizes the resource usage of the specified user, including number of requests, elapsed time, CPU seconds, I/Os, rows returned, and access dates.



Users Report by Resources Used

The following image shows the Users Report by Resources Used, which provides information on resource utilization by user. This report lists users along with the number of requests they submitted, total and average elapsed time, CPU seconds, I/Os, and rows, and their first and last access dates. Click any of the hyperlinked column headings to re-sort the report by that column.

Users Report by Resources Used

This report has one hyperlink that allows you to drill down to another report, as described in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the User column.

Data Source Use by User

Lists the data sources accessed by the specified user, information about the requests, and dates of access. Also allows you to drill down to see column and data type information, as well as procedures used in requests by the specified user.



Users Report by Historical Use

The following image shows the Users Report by Historical Use, which provides information on historical activity by user. This report lists users along with the number of requests they submitted in a particular year and the percentages of their requests and resource usage out of the totals of that year. Click any of the hyperlinked column headings to re-sort the report by that column.

This report has several hyperlinks that allow you to drill down to additional reports, summarized in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the User column.

Data Source Use by User

Lists the data sources accessed by the specified user, information about the requests, and dates of access. Also allows you to drill down to see column and data type information, as well as procedures used in requests by the specified user.

A value under the Year column.

Access per Month for User during Year

Summarizes by month the number of requests made by the specified user, along with the percentage of the user requests and resource usage out of the particular date totals.

A value under the % Total Resources column.

Resources used by User

Summarizes the resource usage of the specified user, including number of requests, elapsed time, CPU seconds, I/Os, rows returned, and access dates.



Procedures Reports

In this section:

The Procedures reports supply a variety of information about the procedures with which users submit requests at your site. This information will help you compare the relative resource usage of cataloged versus ad hoc requests, find out which procedures are the most popular and frequently executed, and thus determine the truly mission-critical applications run at your site.



Procedures Report by Frequency of Use

The following image shows the Procedures Report by Frequency of Use, which provides a summary of procedures being executed. This report lists procedures executed at your site by type, along with statistics about each execution.

Procedures Report by Frequency of Use

This report has one hyperlink that allows you to drill down to another report, as described in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the Procedure Type column.

Request from Procedure Ad hoc

or

Procedure Summary

(depending on procedure type selected)

Lists the date and time, as user, resource, and execution information for all procedures of the specified type. Also allows you to drill down further to see the actual request syntax.



Procedures Report by Resources Used

The following image shows the Procedures Report by Resources Used, which provides a summary of resource utilization by procedure. This report summarizes the resource usage for the procedures executed at your site, including their percentage of total procedures and resources used, as well as total CPU seconds, elapsed time, I/Os, rows, and first and last execution.

Procedures Report by Resources Used

This report has one hyperlink that allows you to drill down to another report, as described in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the Procedure Type column.

Procedure Resource Utilization

Summarizes the executions, users, total and average resource usage, and execution dates for procedures of all types. Also lets you drill down on procedure names to see more detailed usage information as well as the actual request syntax.



Procedures Report by Historical Use

The following image shows the Procedures Report by Historical Use, which provides information on historical activity by procedures. This report summarizes by year the number of executions, users, and percentage of executions and resources used by the types of procedures at your site. Click any of the hyperlinked column headings to re-sort the report by that column.

This report has one hyperlink that allow you to drill down to another report, described in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the Year column.

Procedure Access by Year by Month

Lists the year and month for all executed procedures of the specified procedure type. Also lists their number and percentage of executions, their number of users, and their resource usage percentage.



Data Sources Reports

In this section:

In order to improve system performance at your site, it is helpful to determine which data sources are most mission-critical, most popular among your users, and most resource-intensive. The Data Sources reports show you how your data sources are being accessed, as well as, illustrate various activity patterns at your site and the earliest and latest dates that data was accessed.



Data Sources Report by Frequency of Use

The following image shows the Data Sources Report by Frequency of Use, which provides a summary of data sources being used. This report lists all accessed data sources along with the number and percentage of requests to each data source, the number of users, the percentage of resources consumed, and access dates. Click any of the hyperlinked column headings to re-sort the report by that column.

This report has several hyperlinks that allow you to drill down to additional reports, summarized in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the Data Source column.

Column Level for Data Source Data Source

Shows usage for the columns for the specified data source, including whether they were used with functions, relations, selects, sorts, and groups, and how many days the column has been unused. Also allows you to drill down to see more information about when the columns were used.

A value under the Data Type column.

Data Sources of type Data Type

Lists all the data sources of the specified data type (the engine used in your enterprise) along with the dates of first and last access for each data source.

A value under the Number Requests column.

Request Activity for Data Source: Data Source

Shows request activity for all users of the specified data source, including I/Os, rows returned, and elapsed time. Also allows you to drill down further to see the actual request syntax.

A value under the Number Distinct Users column.

Users of Data Source

Lists all users of the specified data source along with a summary of the resources they have used.

A value under the % Total Requests column.

Procedures Using Data Source

Lists the procedures used to access the specified data source, along with their resource usage and dates of access. Also allows you to drill down on a procedure name to see request information for that procedure and the actual request syntax.

A value under the % Total Resources column.

Resources Used by Data Source

Lists the resources used by the specified data source, sorted by date. Also allows you to drill down on the dates to see more detailed data access information by month.



Data Sources Report by Resources Used

Understanding the patterns of resource usage at your site, including CPU and elapsed time, I/Os, and rows returned, can be helpful in several ways. This kind of information can help you determine which data sources might be good candidates for pre-joining, pre-aggregation, or denormalization, and decide which data to index. In addition, you can monitor users and inform them of their resource usage to encourage them to plan their requests more efficiently. Accessing the Data Sources report category by the Resource Utilization mode of analysis can help you with all of these issues.

The following image shows the Data Sources Report by Resources Used, which provides a summary of resource utilization by data source. This report summarizes the resources used by all data sources at your site, including both total and average elapsed time, CPU seconds, I/Os, and returned rows. Click any of the hyperlinked column headings to re-sort the report by that column.

This report has several hyperlinks that allow you to drill down to additional reports, summarized in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the Data Source column.

Column Level for Data Source Data Source

Shows usage for the columns for the specified data source, including whether they were used with functions, relations, selects, sorts, and groups, and how many days the column has been unused. Also allows you to drill down to see more information about when the columns were used.

A value under the Number of Requests column.

Procedures Using Data Source

Lists the procedures used to access the specified data source, along with their resource usage and dates of access. Also allows you to drill down on a procedure name to see request information for that procedure and the actual request syntax.



Data Sources Report by Historical Use

The accessibility of a Web environment makes rapid growth of your user base inevitable. As more users are accessing more data, monitoring site activity becomes more important, offering you information about the following areas:

  • How much data is being requested.
  • What the busiest times of the day, week, and month are.
  • Which users are most active against which data sources.
  • What standard response times have been.

Accessing the Data Sources report category by historical analysis lets you analyze user activity to determine the peaks and valleys in system usage, supplying you with a solid basis for deciding how to schedule requests, educate users, and so on.

The following image shows the Data Sources Report by Historical Use, which provides information on historical activity by data source. This report summarizes request activity by year and month for all accessed data sources at your site. Click any of the hyperlinked column headings to re-sort the report by that column.

This report has several hyperlinks that allow you to drill down to additional reports, summarized in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the Data Source column.

Column Level for Data Source Data Source

Shows usage for the columns for the specified data source, including whether they were used with functions, relations, selects, sorts, and groups, and how many days the column has been unused. Also allows you to drill down to see more information about when the columns were used.

A value under the Year column.

Data Access for Data Source during Year

Shows data access information for the specified data source and year, including number of requests, elapsed time, CPU seconds, I/Os, and rows returned. Also allows you to drill down on a specific date (month, day, and year) to see request information for that date as well as the actual request syntax.



Procedure Analysis Report

The Procedure Analysis folder contains the Procedure with Errors report, which provides information on error situations by Procedure name.

The following image shows the Procedure Analysis report.

This report has one hyperlink that allows you to drill down to another report, as described in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

Procedure Name

Requests Executed with Errors

Provides a list of requests that resulted in an error.

If you click the hyperlink in the Requests Executed with Errors report, the Error Message Report opens. This report shows all of the error messages generated.



Domain Analysis Report

In this section:

The Domain Analysis Report provides information on the usage of the WebFOCUS domains and their reports and users.

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

The available report is the Domain Usage Report. It provides a summary line of each domain that has been monitored. This report supplies you with information that helps you understand the usage of the domain reports and the users that run them.

Note: In the tables of drill-down links, terms shown in italic represent placeholders, indicating the term can have different values, depending on the selections for that report.



Domain Usage Report

The summary version of the report displays the Domain name, the number of reports from the Domain that have been monitored, the number of users that have run Domain reports that have been monitored, the average execution time of all of the monitored reports in the Domain, and the average CPU time used by all of the monitored reports in the Domain.

Right-click Domain Usage and select Run. Select the column for which you want to examine information under the Column name drop-down menu and click View Report. Any use of a column with that name in any monitored table is reported.

The report window opens, as shown in the following image.

Domain Summary Report

This report has two hyperlinks that allow you to drill down to additional reports summarized in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the Number Monitored Reports column.

Domain by Report Summary report

provides the names of the reports that have been monitored, the number of times the report has been run, the average execution time the used, the average CPU time used, the total number of rows returned by all of the executions and the number of database records processed by all executions of the report. Also allows you to drill down further to view the user names that have executed the report.

A value under the Number Monitored Users column.

Domain by Users Summary report

The report provides the user names that have been monitored, the number of reports the user has run, the average execution time the used, the average CPU time used, the total number of rows returned by all of the executions and the number of database records processed by all executions of the report. Also allows you to drill down further to view names of the reports that the user has run.



Impact Analysis Report

In this section:

The Impact Analysis Report provides information on the affects of column changes.

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

The available report is the Change Impact for Column Report. It provides which procedures and end users will be affected by changes to column names and format. This report supplies you with information that can help you understand the rippling effects of data schema changes.

Note: In the tables of drill-down links, terms shown in italic represent placeholders, indicating the term can have different values, depending on the selections for that report.



Change Impact for Column Report

It is very useful to determine in advance which users and applications will be most affected by impending data source schema changes. The Change Impact for Column reports determine how data-source modifications affect users and their applications.

Right-click Change Impact for Column and select Run. Select the column for which you want to examine information under the Column name drop-down menu and click View Report. Any use of a column with that name in any monitored table is reported.

The report window opens, as shown in the following image. This report summarizes the procedures used to access the specified column.

Change Impact for Column Report

This report has two hyperlinks that allow you to drill down to additional reports summarized in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the Procedure Name column.

Requests from Procedure Procedure Name

Shows a variety of information, including date and time, user, CPU seconds, elapsed time, I/Os, and rows returned, about the requests made with the specified procedure. Also allows you to drill down further to see the actual request syntax.

A value under the Data Source column.

Column Level for Data Source Data Source

Shows usage for the columns for the specified data source, including whether they were used with functions, relations, selects, sorts, groups, or never used. Also allows you to drill down to see more information about when the columns were used.



Performance Analysis Reports

In this section:

Performance Analysis Reports are designed to help reduce excessive overhead. They help identify costly requests and unused data sources that may need to be reviewed to determine if the resource or storage usage could be reduced.

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

The following reports are available:

For more information on the resource and performance analysis issues related to the Resource and Performance Analysis Reports, see What Is Resource Analyzer?.

Note: In the tables of drill-down links, terms shown in italic represent a placeholder, indicating the term can have different values, depending on the selections for that report.



Procedure Benchmarks Report

Benchmarking is a process by which you determine whether your site's service level agreements (SLAs) are being met. Use the Procedure Benchmarks reports to identify response times for requests and other information for analyzing site performance.

Right-click the Procedure Benchmarks report on the tree in the navigation pane and select Run from the context menu. The Report Filter for Procedure Benchmarks window opens.

From the Procedure Name drop-down menu, select the name of the procedure for which you wish to examine information and click View Report.

The Monitored Procedure Detail report appears, as shown in the following image. This report shows information about executions of the specified procedure, including execution date and time, user, CPU and elapsed time, usage type and client type. Click any of the hyperlinked column headings to re-sort the report by that column.

Procedure Benchmark Report


Excessive Resources Report

Some of the most helpful information Resource Analyzer can provide is about which requests are using the most resources. This kind of information helps you identify causes of network and machine-use bottlenecks and enables you to decide what data needs to be indexed, what requests need to be scheduled, or which users need to be educated. The Excessive Resources reports help you with this investigation.

Right-click Excessive Resources and select Run from the context menu. The Report Filter for Excessive Resources window opens, as shown in the following image.

Report Filter for Excessive Resources

For a request to be included in the report, it need only exceed one of the resource values specified, not all. Specify criteria to limit your report to information on requests that consume resource usage values above a certain average and click View Report.

The Excessive Resources report opens, as shown in the following image. This report lists the most resource-intensive procedures, those whose average resource usage values, including CPU seconds, elapsed time, I/Os, and rows returned, exceed at least one of the limits you specified. The report also lists the average resource usage values for each procedure. Click any of the hyperlinked column headings to re-sort the report by that column.

Excessive Resources Report

This report has one hyperlink that allows you to drill down to another report, as described in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the Procedure Name column.

Requests from Procedure Procedure

Lists the date and time, user, and resource information for each request of the specified procedure. Also allows you to drill down further to see the actual request syntax.



Long-running Requests Report

Procedures with long running requests use excessive resources, a particular problem when dealing with operational systems. These procedures should be targeted for optimization.

Right-click Long-running Requests and select Run from the context menu. After specifying report filters, click View Report. The report window opens, as shown in the following image. By default the report is sorted by Average Elapsed Seconds and Average CPU Seconds.

Long Running Requests Report

This report has one hyperlink that allows you to drill down to another report, as described in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the Procedure Name column.

Requests from Procedure: Procedure Name

Shows the requests that were executed from the selected procedure. Also allows you to drill down further to see the actual request syntax.



Large Volume Requests Report

Large volume requests are requests that return more data than might be necessary. These requests can be targeted for optimization. You can identify these reports with the Large Volume Requests Report.

Right-click Large Volume Requests and select Run from the context menu. After specifying report filters, click View Report. The report window opens. By default the report is sorted by Highest Average Rows.

This report has one hyperlink that allows you to drill down to another report, as described in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the Procedure Name column.

Requests from Procedure Name

Shows the requests that were executed from the selected procedure. Also allows you to drill down further to see the actual request syntax.



Dormant Data Report

Dormant data, or data that is very infrequently accessed, can slow response times on your site. Use the Dormant Data reports to identify which data sources and columns have been less recently or never queried and can be deleted or archived to improve performance.

Right-click Dormant Data and select Run from the context menu. After specifying report filters, click View Report. The report window opens.

This report shows a variety of information about each data source, such as number of requests, users, resource usage, and access dates. The Days Since Used column indicates the number of days that have passed since the data source was last accessed. By default, the report is sorted by access dates, with those data sources that have no access dates (and are therefore dormant) listed first, and includes all data sources in the application path, including those that aren't being monitored.

This report has one hyperlink that allows you to drill down to another report, as described in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the Data Source column.

Dormant Data Summary: Column Level for Data Source

Shows which columns were never accessed in the specified data source, and also lists all accessed columns along with last access time in days. Shows usage for the columns, including whether they were used with functions, relations, selects, sorts, and groups.



Excessive Joins Report

Joining too many tables can be slow and costly. De-normalization can be an effective method for cutting CPU time and improving response times. The Excessive Joins reports help you determine which data is most frequently joined by user requests and helps you decide how to plan your de-normalizing strategies.

Right-click Excessive Joins and select Run from the context menu. After specifying report filters, click View Report. The report window opens. This report lists the most frequently joined data sources along with the procedures used to join them.

This report has one hyperlink that allows you to drill down to another report, as described in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the Procedure Name column.

Requests from Procedure Joining Data source1, Data source2, Data sourcen

Shows a variety of information, including date and time, user, CPU seconds, elapsed time, I/Os, and rows returned, about the requests making the specified join. Also allows you to drill down further to see the actual request syntax.



Repeated Aggregations Report

Efficiencies can be created by calculating column values once and storing the results in summary tables for repeated use. This saves the cost of calculating these values every time a report is run.

Right-click Repeated Aggregations and select Run from the context menu. After specifying report filters, click View Report. The Candidates for Summary Level Databases report opens. This report shows how many requests used different functions on certain columns of data sources, along with the dates of access. Click any of the hyperlinked column headings to re-sort the report by that column.

This report has one hyperlink that allows you to drill down to another report, as described in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the Function column.

Procedure Summary - Frequency of Use Using Function on Data Source.Column Name

Summarizes the procedure types (Application and Ad_Hoc) that have executed the specified function for the specified data source and column, along with statistics about each execution. Also allows you to drill down further to see a list of the cataloged procedures and information about them.



Candidates for Column Index Report

Indexing columns that are frequently used in selection criteria for reports can improve efficiency. This report identifies columns that should be indexed.

Right-click Candidates for Column Index and select Run from the context menu. After specifying report filters, click View Report. The report window opens. This report shows how often columns were used as selection criteria in requests. Click any of the hyperlinked column headings to re-sort the report by that column.



Network Analysis Reports

In this section:

This new category of Resource Analyzer reports shows network traffic for requests on the Web server, for example, the users for each connected IP address.

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

The following reports are available:

Note: In the tables of drill-down links, terms shown in italic represent a placeholder, indicating the term can have different values, depending on the selections for that report.



Bandwidth by Procedure Report

The Bandwidth by Procedure report shows the number of bytes retrieved to the Web server for requests. The report analyzes the bandwidth by database type for each year/month combination. Right-click Bandwidth by Procedure and select Run from the context menu. After specifying report filters, click View Report. The report window opens.

This report has one hyperlink that allows you to drill down to another report, described in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the Month column.

Bandwidth Used by Procedure Type during Year/Month.

Shows the bandwidth for each day of the selected year/month.



Resources by Connection

Resources by Connection report shows the resources consumed by the different IP connections.

Right-click Resources by Connection and select Run from the context menu. After specifying report filters, click View Report. The report window opens.

This report has one hyperlink that allows you to drill down to another report, described in the following table.

Drill-Down Hyperlink: Click...

Report Generated

Description

A value under the Connection Address column.

Resources by Connection in Network Node

Shows the resources for each connection address.



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.

The eight Graph Reports appear in the tree:



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.



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 How to Set Selection Criteria Dates for Reports.

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