Versions Compared

Key

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

This appendix includes the following topics:

Anchor
ReportManagerReportsets
ReportManagerReportsets
Report Manager Report sets

Report Manager is a reporting tool that queries the Performance Management Database and displays the results in reports that are generated on a scheduled basis or on demand.

Report Manager provides pre-defined reports divided as follows:•    Availability

  • Availability

...

  • Capacity planning

...

  • Exceptions

...

  • Load Balancing

...

  • Profile

Reports of an Tier-level, for example, provide a performance comparison between the various Tiers of your application.

Reports of an Instance-level provide information about the complete instance, that is the whole system, such as Web Server, an Oracle Instance, or a (J2EE) Java Virtual Machine.

Anchor
CrossTiersReports
CrossTiersReports
Cross-Tiers Reports

Cross-Tier reports contain data for several Tiers, for example, Cross-Tiers Availability report. Application reports are also available for Cross-Tiers reports only.

The Report Manager Cross-Tiers Reports are as follows:•    Availability

  • Availability

•    Load Balancing

...

  • Load Balancing
  • Application

Anchor
Oracle
Oracle
Oracle

The following table lists report sets for Oracle.

Table C-1    Report 1 Report sets for Oracle

Report

...

SetReport Name
AvailabilityInstances
Load BalancingOS Counters
Capacity PlanningLong Term
Capacity PlanningShort Term
ExceptionsActions
ExceptionsApplications

Availability    Instances

Load Balancing    OS Counters

Capacity Planning    Long Term

Capacity Planning    Short Term

Exceptions    Actions

...

(Oracle Apps)

Exceptions    File Systems

Exceptions    Files

...

ExceptionsFile Systems
ExceptionsFiles
ExceptionsForms (Oracle Apps)

...

ExceptionsFunctions (SAP R/3)
Exceptions

Exceptions    Host Users

Exceptions    Instances

Exceptions    Logical Volume

Exceptions    Machines

Exceptions    Modules

Exceptions    Objects

Exceptions    Physical Devices

Exceptions    Programs

Host Users
ExceptionsInstances
ExceptionsLogical Volume
ExceptionsMachines
ExceptionsModules
ExceptionsObjects
ExceptionsPhysical Devices
ExceptionsPrograms
ExceptionsRarely

...

Used and Unused Objects
Exceptions

...

Requests (Oracle Apps)

...

ExceptionsScreens (SAP R/3)

Exceptions    Statements

Exceptions    Storage Devices

...

ExceptionsStatements
ExceptionsStorage Devices
ExceptionsTransactions (SAP R/3)

...

Exceptions    Users

Profile    Actions

...

ExceptionsUsers
ProfileActions
ProfileApplications (Oracle Apps)
Profile

...

Database Size
Profile

...

File Systems

Profile    Files

...

ProfileFiles
ProfileForms (Oracle Apps)

...

Profile    Functions (SAP R/3)

Profile    Host Users

Profile    Instance Statistics

Profile    Instances

Profile    Logical Volume

Profile    Machines

Profile    Modules

Profile    Objects

Profile    Physical Devices

Profile    Programs

Profile    RAC Databases

Profile    Requests (Oracle Apps)

Profile    Schema Changes

ProfileFunctions
ProfileHost Users
ProfileInstance Statistics
ProfileInstances
ProfileLogical Volume
ProfileMachines
ProfileModules
ProfileObjects
ProfilePhysical Devices
ProfilePrograms
ProfileRAC Databases
ProfileRequests (Oracle Apps)
ProfileSchema Changes
ProfileScreens

...

(SAP R/3)

...

Profile    Statements

Profile    Storage Devices

Profile    Transactions (SAP R/3)

...

ProfileStatements
ProfileStorage Devices
ProfileTransactions
ProfileUsers

Anchor
J2EE
J2EE
J2EE

The following table lists report sets for J2EE.

Table C-2    Report 2 Report sets for J2EE

Report

...

Availability    JVMs

Load Balancing    OS Counters

Capacity Planning    Long Term

Capacity Planning    Short Term

Exceptions    Entry Points

Exceptions    JVMs

Profile    Entry Points

SetReport Name
AvailabilityJVMs
Load BalancingOS Counters
Capacity PlanningLong Term
Capacity PlanningShort Term
ExceptionsEntry Points
ExceptionsJVMs
ProfileEntry Points
ProfileJVMs

Anchor
Web
Web

...

Web

The following table lists report sets for Web.

Table C-3    Report 3 Report sets for Web

Report

...

SetReport Name
Load

...

BalancingOS Counters
Capacity

...

PlanningLong Term
Capacity

...

Exceptions    Instances

Exceptions    Locations

Exceptions    Transactions

Exceptions    Users

Profile    Instances

Profile    Locations

Profile    Transactions

PlanningShort Term
ExceptionsInstances
ExceptionsLocations
ExceptionsTransactions
ExceptionsUsers
ProfileInstances
ProfileLocations
ProfileTransactions
ProfileUsers

Anchor
MicrosoftNET
MicrosoftNET

...

Microsoft .NET

The following table lists report sets for Microsoft .NET.

Table C-4    Report 4 Report sets for Microsoft .NET

Report

...

Availability    CLRs

Load Balancing    OS Counters

Capacity Planning    Long Term

Capacity Planning    Short Term

Exceptions    Entry Points

Exceptions    CLRs

Profile    Entry Points

SetReport Name
AvailabilityCLRs
Load BalancingOS Counters
Capacity PlanningLong Term
Capacity PlanningShort Term
ExceptionsEntry Points
ExceptionsCLRs
ProfileEntry Points
ProfileCLRs

Anchor
SQLServer
SQLServer

...

SQL Server

The following table lists report sets for the SQL Server.

Table C-5    Report 5 Report sets for SQL Server

Report

...

Availability    Databases

Availability    Instances

Availability    Overview

Load Balancing    OS Counters

Capacity Planning    Long Term

Capacity Planning    Short Term

Exceptions    Ad-hoc Batches

Exceptions    Applications (COM+)

Exceptions    Client Machines (PeopleSoft)

Exceptions    Components (COM+)

Exceptions    Databases

Exceptions    DB Files

Exceptions    Instances

Exceptions    Logins

Exceptions    Machines

Exceptions    Methods (COM+)

Exceptions    Objects

Exceptions    Physical Disks

Exceptions    Programs

Exceptions    Rarely Used and Unused Objects

Exceptions    Siebel Views

Exceptions    Statements

Exceptions    Storage Devices

Exceptions    Stored Procedures

Exceptions    Transactions (SAP)

Exceptions    User IDs (PeopleSoft)

Exceptions    Users

Exceptions    Work Types

Profile    Ad hoc Batches

Profile    Applications (COM+)

Profile    Client Machines (PeopleSoft)

Profile    Components (COM+)

Profile    Database Definition Changes

Profile    Database Size

Profile    Databases

Profile    DB Files

Profile    Instance Statistics

Profile    Instances

Profile    Logins

Profile    Machines

Profile    Methods (COM+)

Profile    Objects

Profile    Physical Disks

Profile    Programs

Profile    Schema Changes

Profile    Siebel Views

Profile    Statements

Profile    Storage Devices

Profile    Stored Procedures

Profile    Transactions (SAP)

Profile    Unnecessary Indexes

Profile    User IDs (PeopleSoft)

Profile    Users

SetReport Name
AvailabilityDatabases
AvailabilityInstances
AvailabilityOverview
Load BalancingOS Counters
Capacity PlanningLong Term
Capacity PlanningShort Term
ExceptionsAd-Hoc Batches
ExceptionsApplications (COM+)
ExceptionsClient Machines (PeopleSoft)
ExceptionsComponents (COM+)
ExceptionsDatabases
ExceptionsDB Files
ExceptionsInstances
ExceptionsLogins
ExceptionsMachines
ExceptionsMethods (COM+)
ExceptionsObjects
ExceptionsPhysical Disks
ExceptionsPrograms
ExceptionsRarely Used and Unused Objects
ExceptionsSiebel Views
ExceptionsStatements
ExceptionsStorage Devices
ExceptionsStored Procedures
ExceptionsTransactions (SAP)
ExceptionsUser IDs (PeopleSoft)
ExceptionsUsers
ExceptionsWork Types
ProfileAd-Hoc Batches
ProfileApplications (COM+)
ProfileClient Machines (PeopleSoft)
ProfileComponents (COM+)
ProfileDatabase Definition Changes
ProfileDatabase Size
ProfileDatabases
ProfileDB Files
ProfileInstance Statistics
ProfileInstances
ProfileLogins
ProfileMachines
ProfileMethods (COM+)
ProfileObjects
ProfilePhysical Disks
ProfilePrograms
ProfileSchema Changes
ProfileSiebel Views
ProfileStatements
ProfileStorage Devices
ProfileStored Procedures
ProfileTransactions (SAP)
ProfileUnnecessary Indexes
ProfileUser IDs (PeopleSoft)
ProfileUsers
ProfileWork Types

Anchor
SAP
SAP

...

SAP

The following table lists report sets for SAP Systems.

Table C-6    Report 6 Report sets for SAP Systems

Report

...

Availability    Application Servers

Availability    Locales

Availability    Organizations

Availability    Overview

Availability    Systems

Load Balancing    OS Counters

Capacity Planning    Long Term

Capacity Planning    Short Term

Exceptions    Application Servers

Exceptions    Applications

Exceptions    Locales

Exceptions    Organizations

Exceptions    Systems

Exceptions    Transactions

Exceptions    Users

Profile    Application Servers

Profile    Applications

Profile    Locales

Profile    Organizations

Profile    Response Time

Profile    Systems

Profile    Transactions

SetReport Name
AvailabilityApplication Servers
AvailabilityLocales
AvailabilityOrganizations
AvailabilityOverview
AvailabilitySystems
Load BalancingOS Counters
Capacity PlanningLong Term
Capacity PlanningShort Term
ExceptionsApplication Servers
ExceptionsApplications
ExceptionsLocales
ExceptionsOrganizations
ExceptionsSystems
ExceptionsTransactions
ExceptionsUsers
ProfileApplication Servers
ProfileApplications
ProfileLocales
ProfileOrganizations
ProfileResponse Time
ProfileSystems
ProfileTransactions
ProfileUsers

Anchor
Sybase
Sybase

...

Sybase

The following table lists report sets for Sybase.

Table C-7    Report 7 Report sets for Sybase

Report SetReport

...

Name
Capacity

...

PlanningLong Term
Capacity

...

Exceptions    Ad hoc Batches

Exceptions    Database Devices

Exceptions    Databases

Exceptions    Instances

Exceptions    Logins

Exceptions    Machines

Exceptions    Programs

Exceptions    Statements

Exceptions    Stored Procedures

Exceptions    Users

Profile    Ad hoc Batches

Profile    Database Devices

Profile    Database Size

Profile    Databases

Profile    Instances

Profile    Logins

Profile    Machines

Profile    Programs

Profile    Statements

Profile    Stored Procedures

PlanningShort Term
ExceptionsAd Hoc Batches
ExceptionsDatabase Devices
ExceptionsDatabases
ExceptionsInstances
ExceptionsLogins
ExceptionsMachines
ExceptionsPrograms
ExceptionsStatements
ExceptionsStored Procedures
ExceptionsUsers
ProfileAd Hoc Batches
ProfileDatabase Devices
ProfileDatabase Size
ProfileDatabases
ProfileInstances
ProfileLogins
ProfileMachines
ProfilePrograms
ProfileStatements
ProfileStored Procedures
ProfileUsers

Anchor
Tuxedo
Tuxedo

...

Tuxedo

The following table lists report sets for Tuxedo.

Table C-8    Report 8 Report sets for Tuxedo

Report SetReport

...

Name
Load

...

BalancingOS Counters
Capacity

...

PlanningLong Term
Capacity

...

PlanningShort Term

Exceptions    Client IPs

Exceptions    Instances

Exceptions    Server Processes

Exceptions    Services

Exceptions    Users

Profile    Client IPs

Profile    Instances

Profile    Server Processes

Profile    Services

ExceptionsClient IPs
ExceptionsInstances
ExceptionsServer Processes
ExceptionsServices
ExceptionsUsers
ProfileClient IPs
ProfileInstances
ProfileServer Processes
ProfileServices
ProfileUsers

Anchor
WebSphereMQ
WebSphereMQ

...

WebSphere MQ

The following table lists report sets for WebSphere MQ

Table C-9    Report 9 Report sets for WebSphere MQ

Report

...

Availability    Instances

Load Balancing    OS Counters

Capacity Planning    Long Term

Capacity Planning    Short Term

Exceptions    Instances

Exceptions    Queues

Exceptions    Reader Applications

Exceptions    Users

Exceptions    Writer Applications

Profile    Instances

Profile    Queues

Profile    Reader Applications

Profile    Users

Profile    Writer Applications

SetReport Name
AvailabilityInstances
Load BalancingOS Counters
Capacity PlanningLong Term
Capacity PlanningShort Term
ExceptionsInstances
ExceptionsQueues
ExceptionsReader Applications
ExceptionsUsers
ExceptionsWriter Applications
ProfileInstances
ProfileQueues
ProfileReader Applications
ProfileUsers
ProfileWriter Applications

Anchor
OracleApplications
OracleApplications
Oracle Applications

The following table lists report sets for Oracle Applications.

Table C-10    Report 10 Report sets for Oracle Applications

Report SetReport

...

Availability    Instances

Name
AvailabilityInstances
Load BalancingOS

...

Counters
Capacity

...

PlanningLong Term
Capacity

...

PlanningShort Term

Exceptions    Applications

Exceptions    Client IPs

Exceptions    Forms

Exceptions    Instances

Exceptions    Locations

Exceptions    Users

Profile    Applications

Profile    Client IPs

Profile    Forms

Profile    Instances

Profile    Locations

ExceptionsApplications
ExceptionsClient IPs
ExceptionsForms
ExceptionsInstances
ExceptionsLocations
ExceptionsUsers
ProfileApplications
ProfileClient IPs
ProfileForms
ProfileInstances
ProfileLocations
ProfileUsers

Anchor
OS
OS

...

OS

The following table lists report sets for OS (Operating System).

Table C-11    Report 11 Report sets for OS

Report SetReport

...

Name
Load

...

BalancingOS counters
Capacity

...

PlanningLong Term
Capacity

...

Exceptions    Commands

Exceptions    Programs

Exceptions    Servers

Exceptions    Users

Profile    Commands

Profile    Programs

Profile    Servers

PlanningShort Term
ExceptionsCommands
ExceptionsPrograms
ExceptionsServers
ExceptionsUsers
ProfileCommands
ProfilePrograms
ProfileServers
ProfileUsers

Anchor
EMCStorage
EMCStorage

...

EMC Storage

The following table lists report sets for EMC Storage.

Table 12 Report sets for EMC Storage

Report SetReport

...

Name
Capacity

...

PlanningLong Term
Capacity

...

Exceptions    Devices

Exceptions    Front End Directors

Exceptions    Units

Profile    Devices

Profile    Front End Directors

PlanningShort Term
ExceptionsDevices
ExceptionsFront End Directors
ExceptionsUnits
ProfileDevices
ProfileFront End Directors
ProfileUnits

Anchor
Citrix
Citrix

...

Citrix

The following table lists report sets for Citrix Servers.

Table C-13    Report 13 Report sets for Citrix Servers

Report SetReport

...

Exceptions    Citrix Locations

Exceptions    Citrix Users

Exceptions    Client IPs

Profile    Published Applications

Profile    Citrix Locations

Profile    Citrix Users

Profile    Client IPs

Profile    Published Applications

DB2

Name
ExceptionsCitrix Locations
ExceptionsCitrix Users
ExceptionsClient IPs
ProfilePublished Applications
ProfileCitrix Locations
ProfileCitrix Users
ProfileClient IPs
ProfilePublished Applications

Anchor
DB2
DB2
DB2

The following table lists report sets for DB2 Servers.

Table C-14    Report 14 Report sets for DB2 Servers

Report SetReport

...

Profile    Database Partitions

Profile    Programs

Profile    Statements

Profile    Machines

Profile    Modules

Profile    Actions

Profile    OS Users

Profile    DB Users

Profile    Work Types

Exception    Database Partitions

Exception    Programs

Exception    Statements

Exception    Machines

Exception    Modules

Exception    Actions

Exception    OS Users

Exception    DB Users

Exception    Work Types

 

Precise. Performance intelligence from click to storage. Learn more > >

...

Name
ProfileDatabase Partitions
ProfilePrograms
ProfileStatements
ProfileMachines
ProfileModules
ProfileActions
ProfileOS Users
ProfileDB Users
ProfileWork Types
ExceptionDatabase Partitions
ExceptionPrograms
ExceptionStatements
ExceptionMachines
ExceptionModules
ExceptionActions
ExceptionOS Users
ExceptionDB Users
ExceptionWork Types
Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/precise/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...