Adaptive Server includes a set of system tables that contains 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 installmontables script. See “Installing the monitoring tables” for more information.
You must have the mon_role role
to query these tables. For more information, see “The mon_role role”.
