Monitoring tables (also known as MDA tables) are available in Adaptive Server version 12.5.x and later.
After you configure Adaptive Server for monitoring tables, Adaptive Server uses the monitoring tables and sysquerymetrics (particularly after upgrade) to find affected queries as well as changes in system resource consumption.
Configuring the monitoring tables consists of creating a loopback server entry, adding mon_role privileges, and installing the monitor tables from the most current installmontable script. If you previously installed the monitor tables from an earlier release, then applied any EBFs, you may need to reinstall the tables.
Along with the monitoring tables, the sysquerymetrics system table and sp_metrics may be helpful for identifying under-performing queries.
For more information about the monitoring tables, see the Performance and Tuning Guide: Monitoring.
