Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Time Frame tab contains the following properties:

  • Detailed overtime graphs will

...

  • show. Specifies the period for the Overtime graphs.
  • Calculate top

...

  • consumers. Specifies the period by which Report Manager calculates the top entities. This property affects also the summary data in the comparison graphs. Set this period to the same or as part of the period specified in the Detailed Overtime graphs property.
  • Analyze the following hour groups

...

  • only. Specifies the hour groups (for example, All, Night, Day, and Weekend) to include in the report.

To set Profile report properties - time frame tab

  1. Select the time period for the Overtime graphs.
  2. Select the time period by which Report Manager will calculate the top entities.
  3. Select the hour group to include in the report.
  4. Click OK to approve.

Anchor
SettingProfilereportpropertiesfilterstab
SettingProfilereportpropertiesfilterstab
Setting Profile report properties - filters tab

The Filters tab contains the following properties:

  • Analyze only the following

...

  • instances. Format: wildcard1, wildcard2, … where a wildcard is a string that may contain asterisks.
  • Analyze only the following

...

  • databases. This property is available only for SQL server reports. Its format is the same as in the first property.
  • Analyze only the following

...

  • entities. The format is the same as in the first property.
  • Ignore entities with total time less than n

...

  • hours. This property is available only for Oracle and SQL Server reports. It filters entities that are considered not important for reporting.

To set Profile report properties - filters tab

  1. 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.)
  2. If available, type the number of hours for filtering entities.
  3. Click OK to approve.

About the Application Profile report

The Application Profile report is a Cross-Tiers report that provides information related to all the installed Tiers in the application. The Tiers are compared in terms of total time, average execution time, and the number of executions.

...

The Application Profile report structure consists of the following sections:

Anchor
AbouttheOpeningpage
AbouttheOpeningpage
About the Opening page

The summary section provides the number of installed Tiers in the application.

Anchor
AboutTiercomparisongraphs
AboutTiercomparisongraphs
About Tier comparison graphs

The Tier Comparison graphs display summarized values and baselines of the Total Time, Average Time, and Executions for all the Tiers installed in the application.

Anchor
AboutCrossTiersbehaviorovertimegraphs
AboutCrossTiersbehaviorovertimegraphs
About Cross-Tiers behavior overtime graphs

Report Manager generates a Cross-Tiers Behavior Overtime graph for each counter. The counters include the Total Time, Average Time, and Number of Executions. These graphs provide a behavior comparison over time between all installed Tiers.

Anchor
AboutTierspecificbehaviorovertimegraphs
AboutTierspecificbehaviorovertimegraphs
About Tier-specific behavior overtime graphs

Report Manager generates a Behavior Overtime graph for each installed Tier and each counter within the Tier. The counters include the Total Time, Average Time, and Number of Executions. Each graph also contains the counter baseline.

Setting Application Profile report properties - time frame tab

The Properties dialog box of the Application Profile report contains one tab in which you can set the time frame properties, as follows:

  • Detailed Overtime graph will

...

  • show. This property determines the report period in the Overtime graphs.
  • Analyze the following hour groups

...

  • only. This property determines the hour groups (for example, All, Night, Day, and Weekend) to include in the report.

In addition, there is a Description tab which displays a textual description of the report structure and contents.

...

  1. Select the report period for the Overtime graphs.
  2. Select the hour groups.
  3. Click OK to approve.

About the Response time report

Report Manager only generates the Response Time report for SAP Tier (client-side technologies). This report provides information about the response times of your system.

For the SAP Tier, the graph displays for each response time the percentage of SAP transactions accordingly that have a lower response time than a maximum value specified in the report properties - Response time report (general tab).

About the Response time report structure

The Response Time report structure consists of the following sections:

Anchor
AbouttheResponsetimereportopeningpage
AbouttheResponsetimereportopeningpage
About the Response time report - opening page

The summary section provides the number of instances included in the report.

Anchor
AbouttheResponsetimedistributiongraph
AbouttheResponsetimedistributiongraph
About the Response time distribution graph

Report Manager generates a Response Time Distribution graph for each instance running in the Tier. The graph displays a bar for each response time step. Each bar indicates the cumulative percentage and the actual number of executions (SAP transactions in the SAP Tier) that their response time is less or equal to the response time step.

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:

In addition to these three tabs, there is a Description tab which displays a textual description of the report structure and contents.

Anchor
SettingResponsetimereportpropertiesgeneraltab
SettingResponsetimereportpropertiesgeneraltab
Setting Response time report properties - general tab

The General tab contains the following properties:

  • Start the graph with a minimal response time

...

  • of. Specifies the starting response time of the x-axis for which the cumulative response time bar will be calculated.
  • End the graph with a maximal response time

...

  • of. Specifies the ending response time of the x-axis for which the cumulative response time bar will be calculated.
  • Display response time in steps

...

  • of. Specifies the response time distribution of the x-axis.

To set Response time report properties - general tab

  1. In the appropriate fields, type the number of seconds to start and end the response time.
  2. Type the number of seconds for response time distribution.
  3. Click OK to approve.

Anchor
SettingResponsetimereportpropertiestimeframe
SettingResponsetimereportpropertiestimeframe
Setting Response time report properties - time frame tab

The Time Frame tab contains the following properties:

  • Detailed Overtime graph will

...

  • show. Specifies the report period for the Overtime graphs.
  • Analyze the following hour groups

...

  • only. Specifies the hour groups (for example, All, Night, Day, and Weekend) to include in the report.

To set Response time report properties - time frame tab

  1. Select the time period for the Overtime graphs.
  2. Select the hour group to include in the report.
  3. Click OK to approve.

Anchor
SettingResponsetimereportpropertiesfilterstab
SettingResponsetimereportpropertiesfilterstab
Setting Response time report properties - filters tab

The Filters tab contains the following property:

  • Analyze only the following

...

  • instances. Format: wildcard1, wildcard2, … where a wildcard is a string that may contain asterisks.

To set Response time report properties - filters tab

  1. Type the name of the instances to be analyzed.
  2. Click OK to approve.

About the Schema Changes report

Report Manager only generates the Schema Changes report for Oracle and SQL Server Tiers (database technologies). This report displays a chronological log of all changes in the database schema and definition in a tabular format. You can use this report to identify the relations between changes in the database schema and definition to trends in database performance.

To generate this report, Report Manager compares the status of the database at two points in time. Therefore, changes made after the first point in time of which the effect does not remain till the second point in time, will not be shown in the report. For example, a table that was created after the first point in time but was dropped before the second point in time will not appear in the report.

About the Schema Changes report structure

The Schema Changes report structure consists of the following sections:

Info

...

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.

Anchor
AbouttheSchemaChangesreportopeningpage
AbouttheSchemaChangesreportopeningpage
About the Schema Changes report - opening page

The summary section provides the total number of changes detected in the report period.

Anchor
AboutDatabaseDefinitionchanges
AboutDatabaseDefinitionchanges
About Database Definition changes

For the Oracle Tier, the Database Definition Changes Table is part of the Schema Changes report, and the report displays a table for each instance.

For the SQL Server Tier, the Database Definition Changes Table is displayed in a separate report named Database Definition Changes, and the report displays a table for each instance and database.

Anchor
AboutSchemachanges
AboutSchemachanges
About Schema changes

For the Oracle Tier, the report displays a table for each instance. For the SQL Server Tier, the report displays a table for each instance and database.

About Schema Changes report properties

The Properties dialog box contains two tabs in which you can set the Schema Changes report properties:

In addition to these tabs, there is a Description tab which displays a textual description of the report structure and contents.

Anchor
SettingSchemaChangesreportpropertiestimeframetab
SettingSchemaChangesreportpropertiestimeframetab
Setting Schema Changes report properties - time frame tab

The Time Frame tab contains the following property:

  • Analyze

...

  • information. Specifies the report period.

To set Schema Changes report properties - time frame tab

  1. Select the time period for the schema changes report.
  2. Click OK to approve.

Anchor
SettingSchemaChangesreportpropertiesfilterstab
SettingSchemaChangesreportpropertiesfilterstab
Setting Schema Changes report properties - filters tab

The Filters tab contains the following properties:

  • Analyze only the following

...

  • instances. Format: wildcard1, wildcard2, … where a wildcard is a string that may contain asterisks.
  • Analyze only the following

...

  • databases. This property is available only for SQL Server reports. Its format is the same as in the first property.
  • Analyze only the following

...

  • owners. The format is the same as in the first property.

To set Schema Changes report properties - filters tab

  1. In the appropriate fields, type the name of the instances and owners to be analyzed.
  2. Click OK to approve.

Anchor
AbouttheExceptionReportsset
AbouttheExceptionReportsset
About the Exception Reports set

...

The Exception reports set includes reports that have similar structure and properties (standard reports) described in the following topics:

In addition, the Exception reports set includes a report named Unused objects report that has different structure and properties.

Anchor
AbouttheStandardExceptionreportstructure
AbouttheStandardExceptionreportstructure
About the Standard Exception report structure

The standard Exception report consists of the following sections:

An instance for a standard Exception report displays the following tables:

...

  • Exception Summary Table
  • Overtime Behavior Graphs

Anchor
AbouttheExceptionreportopeningpage
AbouttheExceptionreportopeningpage
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 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.

Anchor
AbouttheExceptionreportsummaryheatmatrix
AbouttheExceptionreportsummaryheatmatrix
About the Exception report - summary heat matrix

The Summary Heat Matrix indicates, in a tabular format, the top instances with the most severe exceptions for each of the reported counters. It summarizes the number of deviating entities that are detected and their severity level.

...

In Instance-level reports, the Summary Heat Matrix displays a single row that indicates the average deviation severity and exceptions number in the entire Tier. (This also applies if you chose the Same entity option for the Consider Identically Named Entities in Different Instances property in the Standard exception report - general tab.)

Anchor
AbouttheExceptionreportentityheatmatrix
AbouttheExceptionreportentityheatmatrix
About the Exception report - entity heat matrix

The Entity Heat Matrix page indicates, in a tabular format, the most problematic entities that have the most significant deviations. Each row in the Entity Heat Matrix represents a different entity. Each column represents a different counter. The cell color indicates the severity of the counter deviation from its normal behavior (baseline). The entity name is a link to the Entity Overtime Behavior graphs.

Anchor
AbouttheExceptionreportnewentitiestable
AbouttheExceptionreportnewentitiestable
About the Exception report - new entities table

The New Entities Table lists new entities in the current instance (or Tier in Instance-level reports), which met the report filtering criteria of the minimal consumption amount. Entities are considered new if the Performance Management Database did not calculate a baseline for the entity yet.

For each new entity the table displays its total time value and the percentage that its total time occupies from the entire instance consumption (or Tier consumption in case of Instance-level reports).

Anchor
AbouttheExceptionreportentitymappingtable
AbouttheExceptionreportentitymappingtable
About the Exception report - entity mapping table

The Entity Mapping Table is displayed in reports whose entity names are too long to display in the detailed information pages. Report Manager only generates the Entity Mapping Table for Statements reports, such as the Oracle or SQL Server Exception Report - Statements and the Oracle or SQL Server Exception Report - Ad-hoc Batches.

...

This page contains 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.

Anchor
AboutStandardExceptionreportproperties
AboutStandardExceptionreportproperties
About Standard Exception report properties

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.

...

In addition to these three tabs, there is a Description tab which displays a textual description of the report structure and contents.

Anchor
AbouttheExceptionreportsummarytableandovertimegraphs
AbouttheExceptionreportsummarytableandovertimegraphs
Setting Exception report properties - general tab

The General tab contains the following properties:

...