Page History
...
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 Exception report - summary table and overtime graphs on page 39.
| Anchor | ||||
|---|---|---|---|---|
|
Report Manager generates an Exception Summary Table and Behavior Overtime graphs for each of the reported entities. Each row in the Exception Summary Table includes a deviated counter, with its most recent exception details, including: the Exception Time, the Actual Counter Value, its Baseline Value, and the Percent of Change.
...
The Properties dialog box contains three tabs in which you can set the properties:
- 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.
| Anchor |
|---|
...
|
...
|
The General tab contains the following properties:
- Report the following
...
- exceptions. This property includes an option box for each counter of the entity. Select the counters, by which Report Manager detects the exceptions. The counters and their default selections are different for each Tier and each report within the same Tier.
- Report an exception when baseline is exceeded by more than n
...
- percent. This property determines the percentage by which Report Manager reports the first level exception. One color-code represents this exception in the Heat Matrix.
- Then, escalate exception when baseline is exceeded by more than n
...
- percent. This property determines the percentage by which Report Manager reports the second level exception. This property is optional, that is, if you set it, a second color-code represents this exception in the Heat Matrix.
- Then, escalate exception when baseline is exceeded by more than n
...
- percent. This property is enabled only if the previous one is set. It determines the percentage by which Report Manager reports the third level exception. This property is optional, that is, if you set it, a third color-code represents this exception in the Heat Matrix.
- 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 distinct 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.
- Display Statement Text up to n
...
- characters. This property is available only for SQL statement entity reports. It specifies the maximum number of characters of the Statement Text in the entity mapping table. The default value is 1000 characters.
To set Exception report properties - general tab
- 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.
| Anchor | ||||
|---|---|---|---|---|
|
The Time Frame tab contains the following properties:
- Detailed Overtime graphs will
...
- show. Specifies the period for the Overtime graphs.
- Detect
...
- exceptions. Specifies the period by which Report Manager detects exceptions. 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 Exception report properties - time frame tab
- 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.
| Anchor | ||||
|---|---|---|---|---|
|
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 only available 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 filters exceptions that are not considered important for reporting.
- Ignore entities with total time less than n percent of their
...
- instance. This property provides an additional filtering condition (to the previous one). It uses relative values to filter exceptions that are not considered important for reports that the previous filter did not eliminate. For example, using the previous property, one hour per week may be sufficient for some applications but for others may not.
To set Exception report properties - filters tab
- 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
This report is applicable for database technologies, such as Oracle and SQL Server. The report lists the objects that were not used during the specified time frame of the report. You can use this report to identify cases such as forgotten tables and redundant indices. These cases are frequent in data warehouse applications, which may contain tables and clusters that are not accessed by statements. By dropping these unused objects, you can free disk space without affecting the database performance.
About the Unused Objects report structure
The unused objects report structure consists of the following sections:
| Anchor | ||||
|---|---|---|---|---|
|
The summary section provides the number of unused objects in the report.
| Anchor | ||||
|---|---|---|---|---|
|
Report Manager generates tables of unused objects as follows:
...
The table lists all the unused objects detected during the report period, their owner, and their type.
About the Unused Objects report properties
The Properties dialog box contains two tabs in which you can set the Unused Objects report properties:
- 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.
| Anchor | ||||
|---|---|---|---|---|
|
The Time Frame tab contains the following property:
- Analyze
...
- information. Specifies the report period by which Report Manager detects unused objects.
To set Unused Objects report properties - time frame tab
- Select the time period by which Report Manager detects unused objects.
- Click OK to approve.
| Anchor | ||||
|---|---|---|---|---|
|
The Filters tab contains the following properties:
- Number of blocks greater than
...
- n. This property specifies the minimum number of blocks of objects that Report Manager reports. This eliminates reporting of small objects.
- Consider only the following object
...
- types. This property determines the type of objects to report so that you can concentrate only on a specific object type: Table, Index, or Cluster.
- 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 only available for SQL Server reports. Its format is the same as in the previous property.
- Analyze only the following
...
- owners. The format is the same as in the previous property.
To set Unused Objects report properties - filters tab
- 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.
| Anchor | ||||
|---|---|---|---|---|
|
...