Chat now with support
Chat with Support

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

Start and Stop the Performance Monitor

Performance Monitor > Start and Stop the Performance Monitor

The Performance Monitor provides three ways to monitor the database performance: immediate monitoring, scheduled monitoring, and manual refresh.

The settings on the General tab in Preferences window determine whether the monitoring process begins immediately or at a scheduled time. The monitoring continues to collect the statistics at the refresh interval until you stop the monitoring or until the scheduled end time.

To start the monitoring processing for collecting the database performance statistics

Click image\B_Monitor_PM.gif.

To stop the monitoring process

Click image\B_AbortMonitor_PM.gif.

The manual refresh of the statistics collects the statistics immediately and only collects them once.


Related Topic

Manual Refresh Data

Performance Monitor > Manual Refresh Data

The Manual Refresh Data option is used to check the database performance on ad-hoc basis. The performance snapshot is taken once. This function provides a more flexible statistics retrieval method for troubleshooting a performance problem that is currently happening on the database. It only retrieves the statistics from the monitoring tables when you specifically do the refresh. It retrieves the statistics once and then waits until you manual refresh the data again.

To manually refresh data

Click image\B_ManualRefreshData.gif.

You can set up the monitoring to automatically poll the monitoring tables at regular intervals.

The collection of the Open Database, Open Objects, and the Process statistics are not collected unless the checkbox in front of the statistic is checked in the left pane. The enabling of the retrieval of the statistics for these monitoring options may result in the capture of a large amount of information from the database. Therefore it is not recommended to turn it on when you are using Auto Refresh to continuously monitor the activity of Adaptive Server. But when you need to troubleshoot a current database performance problem, enabling the retrieval of these statistics can help you to quickly identify the problem. Using Manual Refresh Data to take a snapshot can provide good insight on processes running, such as Top N CPU intensive processes information. Processes that are blocked by other processes are marked with a special icon and the related blocking processes can also be displayed.


Related Topic

Hide and Show Console Tree

Performance Monitor > Hide and Show Console Tree

The display of the Console Tree [left pane] in the Performance Monitor window can be toggled between show and hide.

To hide/show the Console Tree

Click .


Chart Information

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating