Chatta subito con l'assistenza
Chat con il supporto

SQL Optimizer for SAP ASE 3.8 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

Right Pane for Information

Performance Monitor > Performance Monitor Window > Right Pane for Information

The Information section in the Performance Monitor provides information about Cache, Processes, SQL Statements, Locks, Sys Worker Threads, Sys Waits and the Error Log.

Cache Information

The Cache Information section has the following information:

Statistic Description

Cached Objects

Provides statistics for all objects and indexes with pages currently in a data cache.

Cached Procedures

Provides statistics for all procedures currently stored in the procedure cache.

Process Information

The Process Information section has the following information:

Statistic Description

Processes

Provides detailed statistics about processes that are currently executing or waiting.

Process Objects

Provides statistical information regarding database objects that have been accessed by processes.

Process Procedures

Provides a list of all procedures that are being executed by processes.

Process Lookup

Provides information enabling processes to be tracked to an application, user, client machine, and so on.

Process Worker Thread

Provides information about process use of worker threads.

Process Waits

Provides a server-wide view of where processes are waiting for an event.

SQL Statement Information

This SQL Statement Information section provides information about currently executing SQL statements and recently executed SQL statement.

Statistic Description

Executing SQL

Provides information for currently executing statements.

Executed SQL

Provides statistics pertaining to the most recently executed statements. The maximum number of statement statistics returned can be set with statement pipe max messages Adaptive Server configuration parameter.

Locks Information

Returns a list of all locks that are being held, and those that have been requested, by any process, for every object.

Sys Worker Threads

Provides server-wide statistics related to worker threads.

Sys Waits

Provides a server-wide view of where processes are waiting for an event.

Error Log

Returns the most recent error messages from the Adaptive Server error log. The maximum number of messages returned can be set with the errorlog pipe max messages Adaptive Server configuration parameter.

 

Related Topic

Status Bar

Performance Monitor > Performance Monitor Window > Status Bar

The status bar at the bottom of the Performance Monitor window has the following information.

Item Description

Server

Adaptive Server name

User

Default user for the login account

Login

Login account name

Interval

Interval setting for retrieving the statistics from the monitoring tables from the Preferences settings.

CNF

The Chart Data Normalization Factor from the Preferences settings.

Monitor Status Icon

When the Monitor Status icon at the far right of the status bar is green image\I_GreenPMStatus.gif, the Performance Monitor is idle. When the Status icon at the far right of the status bar is red image\I_RedPMStatus.gif, it is retrieving the statistics from the monitoring tables.

 

Related Topic

Open the Performance Monitor

Performance Monitor > Open the Performance Monitor

To open the Performance Monitor window

Click image\B_PerformanceMonitor.gif.

 

Related Topic

Connect and Disconnect from Database

Performance Monitor > Connect and Disconnect from Database

When the Performance Monitor window is opened from within SQL Optimizer, the current SQL Optimizer logon is used.

If you open Performance Monitor window outside of SQL Optimizer, you are prompted to logon to a server. You can disconnect from or reconnect to a server without closing the Performance Monitor window.

To connect to a different server

Click image\B_ConnectDatabase.gif.

To disconnect from a server

Click image\B_DisconnectDatabase.gif.

View connection information

To find out if the server has the necessary parameter settings and your current logon has the necessary privileges needed to run the Performance Monitor, select Database | View Connection Information.

The Connection Information window confirms that your logon has the necessary the privileges to run the Performance Monitor or tells which privileges your logon is lacking under the Privilege Information tab.

Certain Adaptive Server configuration parameters are needed to run the Performance Monitor. The Configuration Information tab in the Connection Information window shows the current settings for these parameters and the parameter values that are necessary. If the current parameter value does not meet the required value, the line for configuration parameter is highlighted in red.

 

Related Topic

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione