Monitoring system tables in Adaptive Server

Adaptive Server 12.5.0.3 includes a set of system tables that contain monitoring and diagnostic information. The information in these tables provides you with a statistical snapshot of the state of Adaptive Server, which allows you to analyze the server for performance improvements. You can query these system tables in much the same way you currently query any other tables in Adaptive Server. For example, to display statistical information about I/O on Sybase devices:

select * from monDeviceIO
Reads    APFReads     Writes   DevSemaphoreRequests  DevSemaphoreWaits IOTimeLogicalName PhysicalName
-------- -----------  -------- --------------------  ----------------- ---------------------------------   -------------------------------
1563    7           7891    3                    0             134900
master                        /dev/vx/rdsk/sybase/master_vol01 
59       0             15       2                       0                800 engcomdb_data_vol01           /dev/vx/rdsk/sybase/engcomdb_data_vol01
5       0           13      2                    0             100
engcomdb_log_vol01            /dev/vx/rdsk/sybase/engcomdb_log_vol01
126255  59657       8604    2                    0             1408700
qts_db_data_vol01             /dev/vx/rdsk/sybase/qts_db_data_vol01
31      0           9879    2                    0             128400
qts_db_log_vol01              /dev/vx/rdsk/sybase/qts_db_log_vol01
51      0           19      2                    0             400
sadb_data_vol01               /dev/vx/rdsk/sybase/sadb_data_vol01
5       0           12      2                    0             200
sadb_log_vol01                /dev/vx/rdsk/sybase/sadb_log_vol01
56       0             25       2                       0                900 scratchdb_vol01               /dev/vx/rdsk/sybase/scratchdb_vol01
0       0           0       2                    0              0
rmdb_data_vol01                /dev/vx/rdsk/sybase/rmdb_data_vol01
0        0           0       2                    0               0
rmdb_log_vol01                 /dev/vx/rdsk/sybase/rmdb_log_vol01
52658    424         99512   2                    0               2231300
sysprocsdev                    /dev/vx/rdsk/sybase/sybsystemprocs_vol01
146      0           3569    2                    0               13700
tempdb_data                    /tmp/tempdb_data
4        0           814     2                    0               400
tempdb_log                          /tmp/tempdb_log

Where monDeviceIO is the system table that contains statistical information about disk I/O (physical name, reads, writes, and so on). To perform this query, the user does not need to know if Monitor Server or any other monitoring agent is executing on the same host server; the monDeviceIO table contains all the information they need.

The monitoring tables are not created by default, but must be created using the installmon script in the $SYBASE/ASE-12_5/scripts directory.

NoteYou must have the mon_role role to query these tables.