There are two ways that you can monitor query performance.
Method |
Description |
|---|---|
Default |
Run list queries contained in file <OpsConsoleInstall>/ua/plugins /com.sybase.rap.querystatus/QueryStatusMsg.xml Each query is run against the RAPCache database at the specified collection interval.Use an editor and modify file QueryStatusMsg.xml to add or delete queries. |
Capture performance statistics from ASE Monitor tables |
Refer to the chapter “Monitoring Tables” in the ASE book Performance and Tuning: Monitoring and Analyzing Quick Start Guide for more information on monitor tables.
|
Performance is affected with this option.