Adaptive Server includes a set of system tables that contain monitoring and diagnostic information. The information in these tables provides a statistical snapshot of the state of Adaptive Server, which allows you to analyze the server so as to analyze server performance. For example, you can execute queries to report information about the activity of server processes and applications, query performance, usage of database tables, efficiency of data caches, I/O activity on database devices, and many other aspects of the Adaptive Server that affect system performance.
The data in the monitoring tables is not stored on disk. The data is calculated when you execute a query on one of the monitoring tables. Table definitions are contained in proxy table definitions that are created by a server installation script. These proxy tables use an interface to the Adaptive Server to collect monitoring data when you perform a query.
You must create the monitoring tables using a server installation script. See “Installing the monitoring tables”.
Because Adaptive Server versions may change the definitions of the monitoring tables, Sybase® recommends that when you upgrade, you run the appropriate installation script before using the monitoring tables.
You must have the mon_role to
query these tables. See “The mon_role and additional access controls”.
