Monitoring Tables

The Attributes column in monitoring tables provides information about how the SAP ASE server manages the column.

• monCachedObject
  Stores statistics for all tables, partitions, and indexes with pages currently in a data cache.
• monCachePool
  Stores statistics for all pools allocated for all data caches.
• monCachedProcedures
  Stores statistics for all stored procedures, triggers, and compiled plans currently stored in the procedure cache.
• monCachedStatement
  Stores detailed monitoring information about the statement cache, including information about resources used during the previous executions of a statement, how frequently a statement is executed, the settings in effect for a particular plan, the number of concurrent uses of a statement, and so on. This information can be helpful when troubleshooting, and when deciding which statements to retain in the cache.
• monCIPC
  Applies to cluster environments only. Provides summary figures for total messaging within the cluster, as viewed from the current instance or all instances.
• monCIPCEndpoints
  Applies to cluster environments only. Provides a detailed summary, giving traffic data for each subsystem within the cluster instance.
• monCIPCLinks
  Applies to cluster environments only. Monitors the state of the links between instances in the cluster.
• monCIPCMesh
  Applies to cluster environments only. Gives summary figures for the mesh of connections, from the current instance to all other instances in the cluster, on a per-instance basis.
• monCLMObjectActivity
  Applies to cluster environments only. Collects cluster lock information.
• monClusterCacheManager
  Applies to cluster environments only. Stores diagnostic information about the cluster cache manager daemon running on each instance. monClusterCacheManager reports cluster-wide information on a per-instance basis.
• monCMSFailover
  Applies to cluster environments only. Tracks the time at which the cluster membership service (CMS) detects the failure, gets a new cluster view, resynchronizes the heartbeat, posts the failure event, and completes the failure event. There is a row for each instance.
• monDataCache
  Stores statistics relating to SAP ASE data caches.
• monDBRecovery
  Applies to cluster environments only. Contains rows from all instances in the cluster and contains rows for every database that contributes to recovery.
• monDBRecoveryLRTypes
  Applies to cluster environments only. Tracks log records seen during recovery. Contains a row for each log record type for which at least one log record was seen by recovery.
• monDeadLock
  Provides information about deadlocks. Use deadlock pipe max messages to tune the maximum number of messages returned.
• monDeviceIO
  Returns statistical information relating to activity on database devices.
• monDeviceSpaceUsage
  Provides information about the file systems on which database devices are allocated. Space information is available only for file system devices. File system size and free space values are NULL for database devices allocated on raw devices.
• monEngine
  Provides statistics regarding SAP ASE engines.
• monErrorLog
  Returns the most recent error messages from the SAP ASE error log.
• monFailoverRecovery
  Applies to cluster environments only. Contains aggregated failover recovery diagnostic information for the cluster lock manager (CLM), database recovery, and cluster membership service (CMS) modules.
• monInmemoryStorage
  Provides information about inmemory devices configured to store the contents of inmemory databases.
• monIOController
  Provides information about I/O controllers.
• monIOQueue
  Provides device I/O statistics displayed as data and log I/O for normal and temporary databases on each device.
• monLicense
  Provides a list of all licences currently checked out by the SAP ASE server.
• monLocks
  Returns a list of granted locks and pending lock requests.
• monLockTimeout
  Provides information about lock timeouts. Each row identifies the object on which a blocked lock request occurred, and identities of the blocked and blocking processes.
• monLogicalCluster
  Applies to cluster environments only. Displays information about the logical clusters currently configured on the system.
• monLogicalClusterAction
  Applies to cluster environments only. Shows all administrative actions against logical clusters from start-up until these actions are released.
• monLogicalClusterInstance
  Applies to cluster environments only. Displays information about the many-to-many relationship between instances and logical clusters.
• monLogicalClusterRoute
  Applies to cluster environments only. Displays information about the configured routes (application, login, and alias bindings). You need not have the mon_role role to query this monitor table.
• monMemoryUsage
  The monMemoryUsage monitoring table provides information about server and kernel memory pools, including metrics about their sizes, usage patterns, and availablility.
• monNetworkIO
  Returns network I/O statistics for all communication between the SAP ASE server and client connections.
• monOpenDatabases
  Provides state and statistical information pertaining to databases that are currently in the server’s metadata cache.
• monOpenObjectActivity
  Provides statistics for all open tables and indexes.
• monOpenPartitionActivity
  Provides information about the use of each open partition on the server.
• monPCIBridge
  Contains information about the Java PCI Bridge. This table provides information about the Java environment.
• monPCIEngine
  Displays engine information for the PCI Bridge and its plug-ins. This table provides information about the Java environment.
• monPCISlots
  Contains information about the plug-in bound to each slot in the PCI Bridge. This table provides information about the Java environment.
• monPCM
  Applies to cluster environments only. Tracks the peer coordination module (PCM) client activities in the cluster (for example, the number of fragment that were sent and received), and contains a row for each PCM client.
• monProcedureCache
  Returns statistics relating to SAP ASE procedure cache.
• monProcedureCacheMemoryUsage
  Includes one row for each procedure cache allocator. An allocator is identified by an allocator ID, which is internal to SAP ASE.
• monProcedureCacheModuleUsage
  Includes one row for each module that allocates memory from procedure cache. A module, which is identified with a module ID, is a functional area classification internal to SAP ASE procedure cache management.
• monProcess
  Provides detailed statistics about processes that are currently executing or waiting.
• monProcessActivity
  Provides detailed statistics about process activity.
• monProcessLookup
  Provides identifying information about each process on the server.
• monProcessMigration
  Applies to cluster environments only. Displays information about the connection currently migrating.
• monProcessNetIO
  Provides the network I/O activity information for each process.
• monProcessObject
  Provides statistical information regarding objects currently being accessed by processes.
• monProcessProcedures
  Returns a list of all procedures being executed by processes.
• monProcessSQLText
  Provides the SQL text currently being executed by the process. Use max SQL text monitored to tune the maximum size of the SQL text.
• monProcessStatement
  Provides information about the statement currently executing.
• monProcessWaits
  Provides a list of all wait events for which current processes on the server are waiting. Returns only wait events whose Waits value is greater than zero.
• monProcessWorkerThread
  Provides statistics for the activity of each currently configured worker process.
• monRepCoordinator
  monRepCoordinator provides information on the RAT coordinator process when RAT runs in Multiple Scanner mode.
• monRepLogActivity
  Collects information from monitor counters updated by Replication Agent.
• monRepScanners
  Provides information on where the Rep Agent Scanner task is spending its time
• monRepScannersTotalTime
  Provides information on where the Rep Agent Scanner task is spending its time
• monRepSchemaCache
  The monRepSchemaCache table reports the schema cache information for each scanner running on a Replication Server.
• monRepSenders
  Provides processing information about Rep Agent Sender tasks.
• monSpinlockActivity
  Provides statistics about spinlock activity.
• monSQLRepActivity
  Provides statistics for SQL statements that were successfully replicated on all open objects.
• monSQLRepMisses
  Provides statistics for SQL statements that were not successfully replicated for all open objects.
• monState
  Provides information regarding the overall state of the SAP ASE server.
• monStatementCache
  Provides statistical information about the statement cache. You must enable the statement cache before monStatementCache table can collect data.
• monSysExecutionTime
  The monSysExecutionTime monitoring table includes one row for each operation module executed by Adaptive Server.
• monSysLoad
  Provides trended statistics on a per-engine basis. You need not have the mon_role role to query this monitor table.
• monSysPlanText
  Provides the history of the query plans for recently executed queries. monSysPlanText returns one row of text from each line of the running query plans (similar to what is returned sp_showplan or by set showplan on).
• monSysSQLText
  Provides the most recently executed SQL text, or the SQL text currently executing. The maximum number of rows returned can be tuned with sql text pipe max messages.
• monSysStatement
  Provides a history of the most recently executed statements on the server. Use statement pipe max messages to tune the maximum number of statement statistics returned.
• monSysWaits
  Provides a server-wide view of the statistics for events on which processes have waited.
• monSysWorkerThread
  Returns server-wide statistics related to worker thread configuration and execution.
• monTableColumns
  Describes all the columns for each monitoring table. monTableColumns helps determine what columns are in the monitoring tables. You can join monTableColumns with monTables to report columns and column attributes for the monitoring tables.
• monTableCompression
  Contains the table’s compression history. Enable the enable monitoring, capture compression statistics, and per object statistics active configuration parameters for this monitoring table to collect data.
• monTableParameters
  Provides a description for all columns in a monitoring table used to optimize query performance for the monitoring tables.
• monTables
  Provides a description of all monitoring tables. You can join monTables with monTableColumns for a description of each monitoring table and the columns it contains.
• monTableTransfer
  Provides historical transfer information for tables in the SAP ASE server’s active memory. It does not store information for completed transfers. MonTableTransfer provides transfer information on currently ongoing transfers of all tables, whether they are marked for incremental transfer or not, and on previous transfers on tables marked for incremental transfer.
• monTask
  Specific to the SAP ASE server in threaded mode, contains one row for each task.
• monTempdbActivity
  Applies to cluster environments only. Provides statistics for all open local temporary databases, including global system tempdb when the instance is started in tempdb configuration mode.
• monThread
  Specific to the SAP ASE server in threaded mode: Contains one row for each thread.
• monThreadPool
  Specific to the SAP ASE server in threaded mode: Contains one row for each thread pool.
• monThresholdEvent
  The monThresholdEvent monitoring table includes one row for each event recorded by SAP ASE.
• monWaitClassInfo
  Provides a textual description for all of the wait classes (for example, waiting for a disk read to complete). All wait events (see the description for monWaitEventInfo) have been grouped into wait classes that classify the type of event for which a process is waiting.
• monWaitEventInfo
  Provides a textual description of wait conditions reported in the monSysWaits and monProcessWaits tables.
• monWorkload
  Applies to cluster environments only. Displays the workload score for each logical cluster on each instance according to its load profile.
• monWorkloadPreview
  Applies to cluster environments only. Provides an estimate of how a load profile impacts the workload score without enabling the profile. monWorkload includes one row for each logical cluster and instance on which this logical cluster is running. The load score and components are based on the current profile for that logical cluster. The monWorkloadPreview table has one row for each combination of instance and load profile configured on the system, allowing the administrator to see how workload scoring would be done for each profile. You need not have the mon_role role to query this monitor table.
• monWorkloadProfile
  Applies to cluster environments only. Displays currently configured workload profiles. You need not have the mon_role role to query this monitor table.
• monWorkloadRaw
  Applies to cluster environments only. Provides the raw workload statistics for each instance. You need not have the mon_role role to query this monitor table.
• monWorkQueue
  Provides information on work queues.