Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9 - Release Notes

Performance Monitor Tutorial

The Performance Monitor monitors and retrieved database performance statistics and performance diagnostics metrics from the Adaptive Server (15.0 and later) monitoring tables. The collected statistics are presented graphically and provides a Top-N view that displays the overall database performance health. The graphical view makes it possible to drill down to get the details of different performance statistics such as engines, CPU, devices, processes, cache, lock, and others.

Retrieve statistics from monitoring tables

  1. Click image\B_PerformanceMonitor.gif.

  2. In the Performance Monitor window enable on the left tree view the detailed performance statistics that you want to monitor. By default, general performance statistics are enabled for monitoring.

  3. Click image\B_Monitor_PM.gif to start the monitoring process.

  4. Click image\B_AbortMonitor.gif to stop the monitoring process.

Note: Monitor options and refresh intervals can be changed by in File | Preferences.

 

Related Topic

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating