Page History
...
Report Manager provides pre-defined reports divided into the following report sets:
Profile reports
...
set. These reports provide information about the top n consumers of your application and thus enables you to pinpoint tuning opportunities.
Info
...
A new subset of the Profile reports set is the Geographical reports.
These profile reports provide information about the top n consumers of your application, based on where they are located geographically; whether a state or city in the U.S.A., or a country shown on a two-dimensional world map. These graphic reports enable you to pinpoint tuning opportunities by geographic region.
- Exception reports
...
- set. These reports provide information about any substantial consumption deviating from normal behavior. This information assists you with maintaining your application well tuned.
- Availability reports
...
- set. These reports provide information about failures and downtime of the servers.
- Load balancing reports
...
- set. These reports provide information about servers that are loaded more or less than others, so that you can maintain the load balance of your application.
- Capacity planning reports
...
- set. These reports provide a forecast about future consumption of the current servers. This information is essential for planning your application evolution. For example, you can plan to acquire new hardware or to restrain the consumption.
All the reports are arranged according to the hierarchy of the Tier as shown in the following general example:
- Tier (level 1)
...
-
- Instance (level 2)
- Entity (level 3)
- Entity (level 3)
- Instance (level 2)
- Entity (level 3)
- Entity (level 3)
- Instance (level 2)
Reports of an a 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.
...
The structure of each report, in general, contains the following sections:
- Opening
...
- Page. The opening page is similar for all reports. It contains the following information:
- 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.
- Heat
...
- Matrix. The Heat Matrix is a table that summarizes the report information using a color code to indicate problematic entities or instances. The Heat Matrix differs for each type of report. The Heat Matrix Table is not displayed in reports where this information is not relevant (such as Availability and Exception reports).
- Detailed
...
- Information. The detailed information, which relates to each reported entity, includes tables that list the events and Behavior Overtime graphs.
Report Manager generates all the reports and displays them in PDF format, which enables you to navigate within the report using bookmarks (Navigation pane) on the left and links.
There are two types of links: internal links and launching links. For example, the Heat Matrix contains internal links, which you can click to display its detailed information in the report. The launching links enable you to launch the relevant Precise or Insight product - for further investigation - in context with the information displayed in the report page (same entity, Time Frame, etc.).NOTE You
| Info |
|---|
You can save a copy of a report in your file system and display them later using |
...
Adobe Acrobat |
...
Reader. |
...
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.
| Anchor | ||||
|---|---|---|---|---|
|
...
report 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 Profile report, Report Manager calculates the top n consumers based on counters, such as In MS-SQL Times and Sessions. You can select the counters by which Report Manager calculates the top n consumers through the Standard profile report - general tab of the report properties dialog box. Each type of report may include a different list of counters.
...
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 Entity-level report provides a comparison between the top n entities of each instance in the Tier-level. (This comparison applies in case you chose the Same entity option for the Consider Identically Named Entities in Different Instances property in the Standard profile report - general tab.)
The Profile reports report set includes reports that have similar structure and properties (standard reports). In addition, the Profile reports set includes reports that have different structures and properties.
About the standard profile report structure
The standard Profile report structure consists of the following sections:
- 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:
- For each
...
- instance. Entity Heat Matrix and Entity Mapping Table
- For each
...
- counter. Comparison graphs
- For each
...
- entity. Overtime graphs
| Anchor | ||||
|---|---|---|---|---|
|
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 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.
| Anchor | ||||
|---|---|---|---|---|
|
The Summary Heat Matrix indicates, in a tabular format, the top instances with the most consuming entities for each of the reported counters. Each row of the table specifies an instance, and each column specifies a counter. The cell color-code and the left number, in each column, indicates the rank (order in the top n) of the instance for the specific counter. The right number specifies the normal rank, based on its baseline (for instances with no baseline, a dash sign is displayed instead of the right number).
From this page, you can determine which instance you should start to investigate. Normally, you would choose the instance with the highest value for a selected counter. However, the value of the selected counter for the entire instance does not always point to the significance of the top n consumers. Therefore, the instances are ranked by the combined counter value of the top n consumers, and not by the counter value of the entire instance. For example, in an application that runs two instances, HR and CRM, the top-10 users of the HR instance consume 800 hours out of 1,000 hours of the entire HR instance. The top-10 users of the CRM instance consume 500 hours out of 2,000 hours of the entire CRM instance. Even though the CRM instance consumes more than the HR instance, the CRM instance will be ranked the second, while the HR instance will be the first.
...
- 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.
| Anchor | ||||
|---|---|---|---|---|
|
The Entity Heat Matrix page indicates, in a tabular format, the main consumers of each reported counter. For Instance-level reports, a single Heat Matrix is displayed. For Entity-level reports, an Entity Heat Matrix is displayed for each instance.
Each row of the table specifies an entity, and each column specifies a counter. The cell color-code and the left number, in each column, indicates the rank (order in the top n) of the entity for the specific counter. The right number specifies the normal rank, based on its baseline (for entities with no baseline, a dash sign is displayed instead of the right number).
From this page, you should choose the entity with the highest rank. Each entity name links to the Entity Overtime Behavior graphs.
| Anchor | ||||
|---|---|---|---|---|
|
The Entity Mapping Table is displayed in reports whose entity names are too long to display in the detailed information pages. Report Manager generates the Entity Mapping Table only for the Statements reports, such as Oracle or SQL Server Profile Report - Statements and SQL Server Profile Report - Ad-hoc Batches.
In these reports, the detailed information pages display the statement IDs instead of the Statement Text (also a link to the Entity Mapping Table). See About the Profile report - overtime graphs on page 33.NOTE You
| Info |
|---|
You can specify the maximum number of characters in the Statement Text. |
| Anchor | ||||
|---|---|---|---|---|
|
Report Manager generates a set of Comparison graphs for each of the reported counters. These graphs compare the top n entities of the counter. Instance-level reports have a single set of Comparison graphs for each counter, and Entity-level reports have a set of Comparison graphs for each instance.
Each graph includes a color coded legend. In addition, the legend below the graphs is common to all graphs in the page. This legend maps the number specified in the x-axis of the graph to the entity name (this number is the entity rank). You can click the entity name to display the Entity Overtime Behavior graphs.
| Info |
|---|
...
Although an entity may be displayed in the Heat Matrix, it is omitted in the comparison charts of counters that are not part of their top n consumers. |
| Anchor | ||||
|---|---|---|---|---|
|
Report Manager generates Behavior Overtime graphs for each of the reported entities. Unlike the comparison graphs, all reported entities have the same graph set, regardless of the entities consumption.
The Behavior Overtime graphs contain a launching link to the related Precise or Insight product. You can click the launching link for further investigation in context of the displayed entity. In addition, if the entity name is too long, such as in the Statements report, a link to the Statement Text (Mapping Table) is available.
About standard profile report properties
The Properties dialog box for standard Profile reports contains properties that are specific to the selected report. In general, the properties are similar for all the standard Profile 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 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.
| Anchor | ||||
|---|---|---|---|---|
|
The General tab contains the following properties:
- Calculate top n entities according to the following
...
- counters. This property includes an option box for each counter of the entity (note that the entity is a variable, such as statement, program, and so on). Select the counters, by which Report Manager calculates the top n consumers.
- Consider identically-named entities in different instances to
...
- be. This property is available only for entity-level reports.
Select the Same entities option when the same entities run on different instances, such as in Clustering Systems.
Select the Different entities option to distinguish between the entities of the different instances. - Consider identically-named entities in different databases to
...
- be. This property is available only in reports that relate to the SQL Server Tier. It is similar to the previous one, except that it relates to SQL databases instead of instances.
- Report top n
...
- entities. This property determines the number of top consumers to include in the report.
- 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 tab
- 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.
| Anchor | ||||
|---|---|---|---|---|
|
The Time Frame tab contains the following properties:
...
- 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.
| Anchor | ||||
|---|---|---|---|---|
|
The Filters tab contains the following properties:
...