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.
|
|
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.
|
|
There are three basic Usage Analysis categories:
|
|
Usage Analysis Reports can measure three types of usage:
|
|
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:
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.
|
|
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.
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. |
|
|
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.
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. |
|
|
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. |
|
|
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.
|
|
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.
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. |
|
|
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.
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. |
|
|
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. |
|
|
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.
|
|
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. |
|
|
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. |
|
|
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:
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. |
|
|
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.
|
|
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.
|
|
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.
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. |
|
|
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.
|
|
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.
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. |
|
|
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.
|
|
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.
|
|
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.
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.
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. |
|
|
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.
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 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, 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. |
|
|
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. |
|
|
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. |
|
|
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.
|
|
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.
|
|
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 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. |
|
|
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:
|
|
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.
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.
|
|
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 |