Report Descriptions

The following sections describe specific SiteAnalyzer reports, organized by the general report categories.

In this section: Usage Monitoring Reports Database Reports User Activity Reports Query Reports Field-related Reports Join Reports Time Reports Detail Reports

Usage Monitoring Reports

The following table describes reports containing administration information and custom reports.

Report Name	Description
Monitored samples summary	Provides the date range of monitored data for each database being monitored.
Client-specific reports	Provides access to custom reports.

Database Reports

The following table describes database reports that identify what data is being accessed.

Report Name	Description
Database Use Summary	Provides an overall view of request activity as reflected in the Usage Monitoring Database. Information is summarized by database, providing a quick overview of request volume; average, minimum, and maximum request costs; and first and most recent dates of access. The report gives the Database Administrator (DBA) a starting point to determine which databases warrant further analysis.
Database Use Summary by User	Summarizes database activity for each user.
Database Use Summary by Query	Identifies all databases referenced by individual requests.
Database Use Summary by Column	Identifies multiple databases that use the same column name. This report helps determine if column names are being used inconsistently across different databases.
Most Active Database	Shows request transaction volumes per database, helping the DBA to determine which databases are most frequently and currently accessed and may thus be candidates for warehouse migration or resource governing.
Least Active Database	Helps determine which databases are seldom or no longer accessed, showing request transaction volumes per database.
Most Popular Database	Shows which databases are accessed by the greatest number of users and lists the number of users accessing each database. The report helps the DBA determine which databases are candidates for warehouse migration or resource governing.
Least Popular Database	Helps determine which databases are accessed by the fewest users, showing number of users accessing each database. Databases used by very few users may be candidates for downsizing to a LAN or workstation.
Most Resource Intensive Databases	Ranks databases by highest total resources consumed for all request activity.
Least Resource Intensive Databases	Ranks databases by lowest total resources consumed for all request activity.
Data Access Per Year Per Database	Displays the total number of access instances for individual databases during a year.
Data Access Per Year Per Month Per Database	Displays the total number of access instances for individual databases during a month in a specific year.
Prefix Operators Used	Shows the various operators being used as prefixes (for example, SUM.SALARY).
Prefix Operators Used by Database	Shows the various operators being used as prefixes by database.
Suffix Types Used	Identifies the various suffix types (for example, FIX, SQLDBC, or COM) located in the Master File used in monitored requests.

User Activity Reports

User activity reports identify who requests data. The following table describes database reports that identify what data is being accessed.

Report Name	Description
User Activity Summary	Provides an overview of request activity as summarized by user ID, providing information such as request volume; average, minimum, and maximum request costs; and first and most recent dates of access. The report helps the DBA determine which users are incurring significant costs or request volumes.
User Activity Summary by Database	Summarizes user activity for each database.
User Activity Summary by Query	Identifies and summarizes the activity of all the users of each request.
User Activity Summary by Column	Identifies all the users of a column within a database, including those who would be affected by a format or content change to a particular column.
Most Resource Intensive Users	Ranks users by highest total resources consumed for all request activity.
Most Active Users	Shows which users are most frequently accessing data.
Least Active Users	Helps determine which users are seldom accessing data, showing request transaction volumes per user.
Resource Units By Userid By Date/Time	Lists resource usage by user accumulated for each minute during a day.
Resource Units By Userid	Summarizes each measured resource (CPU, Lines, I/O, and Elapsed) used by a particular user.
Resource Units By Userid Per Day	Summarizes each measured resource (CPU, Lines, I/O, and Elapsed) accumulated daily by a particular user.
Resource Units By Userid Per Month	Summarizes each measured resource (CPU, Lines, I/O, and Elapsed) accumulated monthly by a particular user.
Resource Units by Userid Per Year	Summarizes each measured resource (CPU, Lines, I/O, and Elapsed) accumulated yearly by a particular user.

Query Reports

Query reports identify TABLE requests in detail.

Report Name	Description
Query Use Summary	Provides an overall view of query activity as reflected in the Usage Monitoring Database. Information is summarized by query name, providing a quick overview of request volume; average, minimum, and maximum request costs; and first and most recent dates of access. The report helps the DBA determine which requests warrant further analysis. Requests entered from the command line will be identified as Ad-Hoc.
Query Use Summary By Database	Summarizes request activity for each database.
Query Use Summary By User	Identifies and summarizes request activity for each user.
Query Use Summary By Column	Identifies all the requests that reference a column within a database. These requests might require modification if a format or content change were made to a particular column.
Most Resource Intensive Queries Accumulated	Lists the requests that consume the greatest accumulated amount of resources as defined by the resource calculation.
Most Active Queries	Shows which requests are being executed the most frequently.
Least Active Queries	Shows which requests are seldom used.
Most Popular Queries	Identifies which requests are used by the largest number of users (including ad hoc and batch queries).
Least Popular Queries	Identifies the requests that are used by the fewest users.
Resource Units By Query By Date/Time	Lists the resources used by a particular request, including CPU, Lines, Records, and I/O.
Resource Units By Query	Summarizes each measured resource (CPU, Lines, I/O, and Elapsed) used by a particular request.
Resource Units By Query Per Day	Summarizes each measured resource (CPU, Lines, I/O, and Elapsed) accumulated daily by a particular request.
Resource Units By Query Per Month	Summarizes each measured resource (CPU, Lines, I/O, and Elapsed) accumulated monthly by a particular request.
Resource Units By Query Per Year	Summarizes each measured resource (CPU, Lines, Records, I/O, GetPages, and Elapsed) accumulated yearly by a particular request.
Hold Format Types Used	Shows the various Hold format types used in requests (such as DIF, WP, WKS, and FOCUS).
Query Types Used	Shows the various request types used (for example, TABLE, TABLEF, and SQL).

Field-related Reports

Field-related reports identify the data accessed most often.

Report Name	Description
Column Use Summary	Summarizes the activity and resource usage associated with the access of a particular column in a database.
Column Use Summary By User	Identifies all the columns referenced by a particular user.
Column Use Summary By Query	Identifies all the columns referenced by a particular request.
Potential Index Candidates	Shows columns commonly referenced in IF clauses with an EQ condition, indicating that the column may be a good candidate for indexing.
Most Active Columns For A Database	Shows which columns are most frequently accessed for a given database.
Least Active Columns For A Database	Shows which columns are seldom accessed.
Most Popular Columns For A Database	Shows which columns are accessed by the greatest number of users.
Least Popular Columns For A Database	Shows which columns are accessed by the fewest users.
Ten Most Common BY Columns Used	Lists the ten most common columns used with a BY keyword.
Columns Never Accessed	Shows all the columns by database that have never been directly accessed. This information helps the DBA determine if a database contains unused information.

Join Reports

Join reports identify what data is routinely combined.

Report Name	Description
Join Summary	Identifies all the joins being used by requests and users on your system.
Users Performing Joins for Reports	Lists all users performing joins within their requests.

Time Reports

Time reports identify peak request periods, enabling you to improve performance and response time.

Report Name	Description
Hourly Use Summary	Provides an overall view of request activity as reflected in the Usage Monitoring Database. Information is summarized by hour, providing a quick overview of request volume; average, minimum, and maximum request costs; and first and most recent dates of access. The report helps the DBA determine what times are busiest.
Daily Use Summary	Provides an overall view of request activity as reflected in the Usage Monitoring Database. Information is summarized by day of week, providing a quick overview of request volume; average, minimum, and maximum request costs; and first and most recent dates of access. The report helps the DBA determine what times are busiest.
Monthly Use Summary	Provides an overall view of request activity as reflected in the Usage Monitoring Database. Information is summarized by month, providing a quick overview of request volume; average, minimum, and maximum request costs; and first and most recent dates of access. The report helps the DBA determine what times are busiest.
Data Access Per Year	Displays the total number of access instances for all databases during a year.
Data Access Per Year Per Month	Displays the total number of access instances for individual databases during a month.

Detail Reports

Detail reports contain system resource usage information.

Report Name	Report Description
Most Resource Intensive Users Indiv	Lists the users that consumed the greatest amount of resources as defined by the resource calculation.
Most Resource Intensive Queries Indiv	Lists the individual requests that consumed the greatest amount of resources as defined by the resource calculation.