Monitoring Performance Skip Navigation
Essbase® Analytic Services Database Administrator's Guide | Update Contents | Previous | Next | Print | ? |
Information Map

Monitoring Performance


This chapter describes Analytic Server diagnostic information and tells you how to display that information. Use this information to monitor Analytic Services configuration or performance.

This chapter contains the following sections:

For a comprehensive discussion of activity, error and exception logs, see Monitoring Data, Applications, and Databases. For information about specific error messages, see the Error Messages Guide in \docs\errmsgs\erhelp.htm in the Analytic Services installation.

Finding Diagnostic Information

Analytic Services provides performance information dialog boxes at the Analytic Server, application, and database level. View performance information before completing any of these tasks:

Analytic Services displays information on a snapshot basis; to see the latest information, click the Refresh button for a new snapshot. The Refresh button, if it is displayed in a window or dialog box, refreshes every tab in the window or dialog box, not just the current tab.

For a comprehensive discussion of Analytic Server, application, and outline logs, see Analytic Server and Application Logs.

The following sections provide detailed procedures for accessing information about Analytic Servers, applications, and databases that are commonly used to diagnose performance or other issues.

Viewing Analytic Server Information

You can view information about the Analytic Server license, configuration, operating system, disk drives, and applications for Analytic Server.

To view Analytic Server information, use any of the following methods:


Tool
Topic
Location

Administration Services

Monitoring Analytic Servers

Essbase Administration Services Online Help

MaxL

display application

Technical Reference

ESSCMD

GETAPPSTATE

GETPERFSTATS

Technical Reference



Viewing Application Information

You can view application information to identify which databases are running in the application and to check access, security, and start-up information.

To view application information, use any of the following methods:


Tool
Topic
Location

Administration Services

Monitoring Applications

Essbase Administration Services Online Help

MaxL

display application

Technical Reference

ESSCMD

GETAPPSTATE

GETPERFSTATS

Technical Reference



Viewing Database Information

You can view information about database storage, database statistics, and lock contention. This information may help you identify activities or operations that affect performance.

To view database information, use any of the following methods:


Tool
Instructions
For More Information

Administration Services

Monitoring Databases

Essbase Administration Services Online Help

MaxL

display database

Technical Reference

ESSCMD

  • For general information: GETDBINFO

  • For database storage information: GETDBSTATE

  • For currency information: GETCRDBINFO

  • For database statistics: GETDBSTATS

  • For run-time information: GETDBINFO

Technical Reference



Monitoring Application/Database Status

You can view the start/stop status of applications and databases that you are authorized to use.

To view application/database status, use any of the following methods:


Tool
Instructions
For More Information

Administration Services

Viewing Application/Database Status

Essbase Administration Services Online Help

ESSCMD

GETAPPINFO

GETDBINFO

Technical Reference



Monitoring User Sessions and Requests

You can monitor active user sessions for an Analytic Server, application, or database. If you have Supervisor or Application Designer permissions, you can disconnect a user session or terminate a specific request made during a session. for more information, see Disconnecting Users and Terminating Requests.

To monitor user sessions and requests, use any of the following methods:


Tool
Instructions
For More Information

Administration Services

Viewing Active User Sessions

Essbase Administration Services Online Help

MaxL

display session alter system

Technical Reference



Monitoring Applications from the Operating System

Each application that is loaded is an open task or process in the operating system. You can use the operating system to view application tasks or processes:



Hyperion Solutions Corporation link