Page History
The section includes the following topics:• Introducing
- Introducing Report Manager reports
...
- About the Profile reports set
...
- About the Exception Reports set
...
- About the Availability reports set
...
- About the Load Balancing Reports set
...
- About the Capacity Planning reports set
Introducing Report Manager reports
Report Manager provides pre-defined reports divided into the following report sets:
...
Tier (level 1) Instance (level 2)• Entity
- Entity (level 3)
...
- Entity (level 3)
Instance (level 2)• Entity
- Entity (level 3)
...
- Entity (level 3)
Reports of an Tier-level, for example, provide a performance comparison between the various Tiers of your application. These reports can contain data of several Tiers, for example, Cross-Tiers Availability reports.
...
Opening Page The opening page is similar for all reports. It contains the following information:• Report
- Report name
...
- Report description
...
- Summary about the report content
...
- Report execution date-and-time
...
- Report properties of the last execution
Summary The Summary pages include comparison graphs (where applicable) or a Summary Heat Matrix (overview information), from which you can determine which instance you should start to investigate. Also available are comparison graphs displayed on a map of a geographic region, such as the United States, or on a world map.
...
Launching links are available only for reports where this option is enabled. To launch a Precise or Insight product, click the link on the upper right-hand corner of the window. See Setting the General settings on page 27.
About the Profile reports set
The Profile reports provide information about the top n consumers of the application. The consumers can be either Entities such as programs and users, or Instances such as JVMs, SAP Systems, and Oracle Instances.
...
For each Tier, Report Manager provides the following report types:• A
- A Profile report at the Instance-level.
...
- Profile reports at the Entity-level for the entities in the Tier.
The Instance-level report provides a comparison between the top n instances and displays over time information for each one of the top n instances.
...
The standard Profile report structure consists of the following sections:• About
- About the Profile report - opening page
...
- About the Profile report - summary heat matrix
...
- About the Profile report - entity heat matrix
...
- About the Profile report - entity mapping table
...
- About the Profile report - comparison graphs
...
- About the Profile report - overtime graphs
The following information is displayed:
...
The opening page of the Profile report is similar to all the pre-defined reports except that the summary section provides information related to the specific report as follows:• Number
- Number of new entities among the top n consumers. A new entity means that the Performance Management Database did not yet calculate a baseline for the entity.
...
- Number of entities that normally are not among the top n consumers, and also are not new.
About the Profile report - summary heat matrix
...
The Summary Heat Matrix applies only if the report meets all the following conditions:• The
- The report is an Entity-level Profile report.
...
- The report contains more than one instance.
...
- You chose the Different entity option for the Consider Identically Named Entities in Different Instances property. See Setting Profile report properties - general tab on page 34.
About the Profile report - entity heat matrix
...
From this page, you should choose the entity with the highest rank. Each entity name links to the Entity Overtime Behavior graphs.
About the Profile report - entity mapping table
...
The Properties dialog box contains three tabs in which you can set the properties:• Setting
- Setting Profile report properties - general tab
...
- Setting Profile report properties - time frame tab
...
- Setting Profile report properties - filters tab
In addition to these three tabs, the Description tab displays a textual description of the report structure and contents.
...
Display statement text up to n characters This property is available for SQL Statement, Ad-hoc Batches, and Stored Procedures Entity reports. It specifies the maximum number of characters of the Statement Text in the Entity Mapping Table. The default value is 1000 characters. Note that “statement” is a variable.
To set Profile report properties - general tab1. Select
- Select the counters for the entity.
...
- If available, you can select an option for each of the drop-down menus.
...
- Type the number of top consumers to be included in the report.
...
- If available, type the maximum number of characters for the Statement Text in the Entity Mapping table.
...
- Click OK to approve.
Setting Profile report properties - time frame tab
...
To set Profile report properties - time frame tab1. Select
- Select the time period for the Overtime graphs.
...
- Select the time period by which Report Manager will calculate the top entities.
...
- Select the hour group to include in the report.
...
- Click OK to approve.
Setting Profile report properties - filters tab
...
To set Profile report properties - filters tab1. In
- In the appropriate fields, type the name of the instances, databases, statements, and etc. to be analyzed. (For instances you can click the browse button and select an instance from the list.)
...
- If available, type the number of hours for filtering entities.
...
- Click OK to approve.
About the Application Profile report
...
The Application Profile report structure consists of the following sections:• About
- About the Opening page
...
- About Tier comparison graphs
...
- About Cross-Tiers behavior overtime graphs
...
- About Tier-specific behavior overtime graphs
About the Opening page
The summary section provides the number of installed Tiers in the application.
...
To set Application Profile report properties - time frame tab1. Select
- Select the report period for the Overtime graphs.
...
- Select the hour groups.
...
- Click OK to approve.
About the Response time report
...
The Response Time report structure consists of the following sections:• About
- About the Response time report - opening page
...
- About the Response time distribution graph
About the Response time report - opening page
...
Executions of which the response time is greater than the specified maximal value, are not included in the graph, and therefore the percentage of the total executions may not add up to 100 percent.
About Response time report properties
The Properties dialog box contains three tabs in which you can set the Response Time report properties:• Setting
- Setting Response time report properties - general tab
...
- Setting Response time report properties - time frame
...
- Setting Response time report properties – filters tab
In addition to these three tabs, there is a Description tab which displays a textual description of the report structure and contents.
...
To set Response time report properties - general tab1. In
- In the appropriate fields, type the number of seconds to start and end the response time.
...
- Type the number of seconds for response time distribution.
...
- Click OK to approve.
Setting Response time report properties - time frame tab
...
To set Response time report properties - time frame tab1. Select
- Select the time period for the Overtime graphs.
...
- Select the hour group to include in the report.
...
- Click OK to approve.
Setting Response time report properties - filters tab
...
To set Response time report properties - filters tab1. Type
- Type the name of the instances to be analyzed.
...
- Click OK to approve.
...
About the Schema Changes report
...
The Schema Changes report structure consists of the following sections:• About
- About the Schema Changes report - opening page
...
- About Database Definition changes
...
- About Schema changes
NOTE For the SQL Server Tier, the report only displays the schema changes. The database definition changes are displayed in a separate report named Database Definition Changes.
...
The Properties dialog box contains two tabs in which you can set the Schema Changes report properties:• Setting
- Setting Schema Changes report properties - time frame tab
...
- Setting Schema Changes report properties - filters tab
In addition to these tabs, there is a Description tab which displays a textual description of the report structure and contents.
...
To set Schema Changes report properties - time frame tab1. Select
- Select the time period for the schema changes report.
...
- Click OK to approve.
Setting Schema Changes report properties - filters tab
...
To set Schema Changes report properties - filters tab1. In
- In the appropriate fields, type the name of the instances and owners to be analyzed.
...
- Click OK to approve.
About the Exception Reports set
The Exception reports provide information about any substantial consumption deviating from the normal behavior. This information assists you with maintaining your application well-tuned.
For each Tier, Report Manager provides the following Exception report types:• Instance
- Instance-level report type, which provides information about any deviation of the total instance's consumption.
...
- Entity-level report type, which provides information about any deviation of the entity's consumption. Most of the Exception reports are Entity-level reports.
The counters set may be different for each Tier. In addition, the counters may be different between the various reports in the same Tier. You can set the counters for each report.
...
The Exception reports set includes reports that have similar structure and properties (standard reports) described in the following topics:• About
- About the Standard Exception report structure
...
- About Standard Exception report properties
In addition, the Exception reports set includes a report named Unused objects report that has different structure and properties.
...
The standard Exception report consists of the following sections:• About
- About the Exception report – opening page
...
- About the Exception report - summary heat matrix
...
- About the Exception report - entity heat matrix
...
- About the Exception report - new entities table
...
- About the Exception report - entity mapping table
...
- About the Exception report - summary table and overtime graphs
An instance for a standard Exception report displays the following tables:• Entity
- Entity Heat matrix
...
- New Entities table
...
- Entity Mapping table
The following information is displayed for each entity:• Exception
- Exception Summary Table
...
- Overtime Behavior Graphs
About the Exception report - opening page
The opening page of the Exception report is similar to all the pre-defined reports except that the summary section provides information related to the specific report as follows:• Number
- Number of entities that met the exception criteria, with their mean deviation and maximal deviation from the baseline.
...
- Total number of exceptions and their distribution among the various counters.
...
- Number of new entities within the Tier. A new entity means that the Performance Management Database did not yet calculate a baseline for the entity.
About the Exception report - summary heat matrix
...
The Properties dialog box for Standard Exception reports contains properties that are specific to the selected report. In general, the properties are similar for all the Standard Exception reports. However, you may find some differences according to the relevancy of the property to the report.
The Properties dialog box contains three tabs in which you can set the properties:• Setting
- Setting Exception report properties - general tab
...
- Setting Exception report properties - time frame tab
...
- Setting Exception report properties - filters tab
In addition to these three tabs, there is a Description tab which displays a textual description of the report structure and contents.
...
To set Exception report properties - general tab1. Check
- Check the desired exceptions.
...
- Type the desired percent number by which Report Manager reports the first level exception.
...
- Check and type the percent number if you want Report Manager reports for second level and third level exceptions.
...
- If available, you can select an option for each of the drop-down menus.
...
- If available, type the maximum number of characters for the Statement Text in the Entity Mapping table.
...
- Click OK to approve.
Setting Exception report properties - time frame tab
...
To set Exception report properties - time frame tab1. Select
- Select the time period for the Overtime graphs.
...
- Select the time period by which Report Manager detects exceptions.
...
- Select the hour group to include in the report.
...
- Click OK to approve.
Setting Exception report properties - filters tab
...
To set Exception report properties - filters tab1. In
- In the appropriate fields, type the names of the instances, databases, statements, and etc. to be analyzed. (For instances you can click the browse button and select an instance from the list.)
...
- If available, type the number of hours for filtering exceptions.
...
- If desired, type the percent number for an additional filter to exceptions.
...
- Click OK to approve.
About the Unused Objects report
...
The unused objects report structure consists of the following sections:• About
- About the Unused Objects report - opening page
...
- About the Unused Objects table
About the Unused Objects report - opening page
...
Report Manager generates tables of unused objects as follows:• For
- For the Oracle Tier, one table for each instance and schema owner.
...
- For the SQL Server Tier, one table for each instance, database, and schema owner.
The table lists all the unused objects detected during the report period, their owner, and their type.
...
The Properties dialog box contains two tabs in which you can set the Unused Objects report properties:• Setting
- Setting Unused Objects report properties - time frame tab
...
- Setting Unused Objects report properties - filters tab
In addition to these tabs, there is a Description tab which displays a textual description of the report structure and contents.
Setting Unused Objects report properties - time frame tab
...
To set Unused Objects report properties - time frame tab1. Select
- Select the time period by which Report Manager detects unused objects.
...
- Click OK to approve.
Setting Unused Objects report properties - filters tab
...
To set Unused Objects report properties - filters tab1. Type
- Type the minimum number of blocks for objects that Report Manager reports.
...
- Select the type of objects to report.
...
- In the appropriate fields, type the name of the instances, databases, and owners to be analyzed.
...
- Click OK to approve.
About the Availability reports set
The Availability reports provide information about failure and downtime of Tiers in your application. For most Tiers, Report Manager tracks only the Instance availability. However, for some Tiers, such as SAP and SQL Server, Report Manager also tracks the availability of other entities.
Report Manager provides the following Availability report types:• Instance
- Instance-level Availability report type for all Tiers except OS. This report type provides information about the availability of all the instances in the Tier.
...
- Entity-level Availability report type for entities other than Instance-level, whose availability is being tracked.
...
- Availability Overview report type for Tiers that include Entity-level reports. The Overview report provides a summary of the Tier availability, by combining the availability information of the Instance-level and Entity-level in one table.
...
- Cross-Tiers Availability report that summarizes the availability information of all Tiers in one report.
The availability percentage calculation takes into account planned down time, which can be configured through Precise AdminPoint. For more information, see the Precise Administration Guide.
When Report Manager generates an Availability report, it checks if an instance availability falls below its availability threshold, unless there is no information (regarding availability) for the Tier. For example, a newly installed Tier may not have data currently available regarding availability; in this case a bar labeled Unknown appears on the graph. If an instance availability falls below its availability threshold, Report Manager sends an alert to Alerts. Likewise, when working in Alerts, you can drill down to the relevant Availability report from the Alerts user interface. For more information, see the Alerts User's Guide.
About the Instance-level Availability report structure
The Instance-level Availability report structure consists of the following sections:• About
- About the Instance-level Availability report - opening page
...
- About the Tier Availability table
...
- About the Instance-level Availability Overtime graphs
About the Instance-level Availability report - opening page
The opening page of the Instance-level Availability report is similar to all the pre-defined reports except that the summary section provides information related to the specific report as follows:• Number
- Number of reported instances, and their average and minimal availability within the report period.
About the Tier Availability table
...
Report Manager generates, by default, Overtime graphs for each instance that its availability is below the threshold. The Availability Overtime graphs include the following:• An
- An Availability graph that displays the availability percentage of the instance along with the threshold. For a Tier where no data is currently available, the bar appears as Unknown in the graph.
...
- An Unavailability graph that displays the duration of the instance unavailability.
To generate Overtime graphs of instances with availability above the threshold, modify the report properties and rerun it. See Setting Availability report properties - filters tab on page 46.
...
The Entity-level Availability report structure consists of the following sections:• About
- About the Entity-level Availability report - opening page
...
- About the Entity-level Availability report - summary table
The following information is displayed for each instance:• About
- About the Entities Availability table
...
- About the Entities Availability Overtime graphs
About the Entity-level Availability report - opening page
The opening page of the Entity-level Availability report is similar to all the pre-defined reports except that the summary section provides information related to the specific report as follows:• Number
- Number of Reported Entities
...
- Their Average and Minimal Availability within the report period
...
About the Entity-level Availability report - summary table
This Summary Table compares all the instances of the Tier by the availability of their entities. The Summary table contains a row for each reported instance that displays:• Its
- Its Total Amount of Entities
...
- The Number of Entities with Availability Problems
...
- The Average Entities Availability within the report period
About the Entities Availability table
...
Report Manager generates, by default, Overtime graphs for each entity that its availability is below the threshold. The Availability Overtime graphs include the following:• An
- An Availability graph that displays the availability percentage of the entity along with the threshold.
...
- An Unavailability graph that displays the duration of the entity unavailability.
To generate Overtime graphs of entities with availability above the threshold, modify the report properties and rerun it. See Setting Availability report properties - filters tab on page 46.
...
The Availability Overview report structure consists of the following sections:• About
- About the Availability Overview report - opening page
...
- About the Availability Overview table
About the Availability Overview report - opening page
The opening page of the Availability Overview report is similar to all the pre-defined reports except that the summary section provides information related to the specific report as follows:• For
- For each reported entity type, Number of Entities and their Average and Minimal Availability within report period.
About the Availability Overview table
...
The Cross-Tiers Availability report structure consists of the following sections:• About
- About the Cross-Tiers Availability report - opening page
...
- About the Application Availability table
...
- About Availability Overtime graphs
...
About the Cross-Tiers Availability report - opening page
The opening page of the Cross-Tiers Availability report is similar to all the pre-defined reports except that the summary section provides information related to the specific report as follows:• Number
- Number of reported Tiers and their Average and Minimal Availability within the report period.
About the Application Availability table
...
Report Manager generates, by default, Overtime graphs for each Tier of which its availability is below the threshold. The Availability Overtime graphs include the following:• An
- An Availability graph that displays the availability percentage of the Tier along with the threshold.
...
- An Unavailability graph that displays the duration of the Tier unavailability.
To generate Overtime graphs of Tiers with availability above the threshold, modify the report properties and rerun it. See Setting Availability report properties - filters tab on page 46.
...
The Properties dialog box for the Availability reports contains two tabs in which you can set the properties:• Setting
- Setting Availability report properties - time frame tab
...
- Setting Availability report properties - filters tab
In addition to these tabs, there is a Description tab which displays a textual description of the report structure and contents.
...
To set Availability report properties - time frame tab1. Select
- Select the time period by which Report Manager calculates the availability percentage and determines the events to display in the Overtime graphs.
...
- Select the hour groups to include in the report.
...
- Click OK to approve.
Setting Availability report properties - filters tab
...
Generate Overtime graphs only for entities which did not comply with their availability threshold Clear this option box to display Availability Overtime graphs also for entities that their availability is above the threshold.
To set Availability report properties - filters tab
...