Sybase Adaptive Server Enterprise Database Metrics
Release 8 or lower KPID of the process
3.47 Configuration Metrics
Configuration metrics consist of the following categories.
3.47.1 Sybase ASE Version Metrics
The metrics in this category provide details about the version of Sybase ASE. Default Collection Interval — Every 24 hours
Object Type Type of object.
Owner Name Name of the object owner.
For Release 6
Number of Processes Currently Accessing the Object (per sec)
For Release 7
Process Access Rate of the Object (per sec)
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)
Number of processes currently accessing the object.
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)
Rate at which the processes are currently accessing the object, that is, the number of processes that have started accessing the object since last collection divided by the elapsed time between two collections.
Table 3–46 Top Ten Frequently Accessed Cached Objects Metrics
Metric Description
Cached Object Size Number of kilobytes of the cache the object is occupying. Cache Name Name of the cache.
DB Name Name of the database. Object Name Name of the object. Object Type Type of object.
Owner Name Name of the object owner.
For Release 6
Number of Processes Currently Accessing the Object (per sec)
For Release 7
Process Access Rate of the Object (per sec)
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)
Number of processes currently accessing the object.
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)
Rate at which the processes are currently accessing the object, that is, the number of processes that have started accessing the object since last collection divided by the elapsed time between two collections.
Table 3–45 (Cont.) Top Ten Big Cached Objects Metrics
Configuration Metrics
3.47.2 System Listeners Metrics
The metrics in this category provide details about the system listeners. Default Collection Interval — Every 24 hours
3.47.3 System Databases
The metrics in this category provide details about the databases used. Default Collection Interval — Every 24 hours
3.47.4 Installed Scripts
The metrics in this category provide details about the installed scripts. Default Collection Interval — Every 24 hours
3.47.5 Charsets Information
The metrics in this category provide details about the charsets. Default Collection Interval — Every 24 hours
Table 3–47 Sybase ASE Version Metrics
Metric Description
Version Version of Sybase ASE.
Table 3–48 System Listeners Metrics
Metric Description
ASE Server Name and Port
Name of the ASE Server and the associated port.
Network Protocol Network protocol used.
Table 3–49 System Databases Metrics
Metric Description
Database Name Name of the database used.
Database Size Size of the database used.
Owner Name Name of the owner of the database. Database ID Unique ID of the database.
Date of Creation Date when the database was created. Status Current status of the database.
Table 3–50 Installed Scripts Metrics
Metric Description
Script Name Name of the installed script.
Version Version of the installed script. Status Current status of the script.
Configuration Metrics
3.47.6 Configuration Parameters
This section is a grouping of the following configuration parameters metric categories:
■ Backup/Recovery Configuration Parameters ■ Cache Manager Configuration Parameters
■ Component Integration Services Configuration Parameters ■ Configuration Options Configuration Parameters
■ DTM Administration Configuration Parameters ■ Diagnostics Configuration Parameters
■ Disk I/O Configuration Parameters ■ Error Log Configuration Parameters
■ Extended Stored Procedure Configuration Parameters ■ General Information Configuration Parameters ■ Java Services Configuration Parameters
■ Languages Configuration Parameters ■ Lock Manager Configuration Parameters ■ Memory Use Configuration Parameters ■ Meta-Data Caches Configuration Parameters ■ Monitoring Configuration Parameters
■ Network Communication Configuration Parameters ■ O/S Resources Configuration Parameters
■ Physical Memory Configuration Parameters ■ Physical Resources Configuration Parameters ■ Processors Configuration Parameters
■ Rep Agent Thread Administration Configuration Parameters ■ Security Related Configuration Parameters
■ SQL Server Administration Configuration Parameters ■ Unicode Configuration Parameters
■ User Environment Configuration Parameters
Table 3–51 Charsets Information Metrics
Metric Description
Entity Type Type of charset entity.
ID Unique ID assigned to the entity. Charset ID Unique ID assigned to the charset. Status Status of the charset.
Charset Name Name of the charset.
Description A brief description of the charset. Sort File Name of the associated sort file.
Configuration Metrics
The default collection interval for all these metric categories is — Every 24 hours All these metric categories provide the following details:
3.47.7 Database Instances
The metrics in this category provide details about the database instances. The default collection interval for all these metric categories is — Every 1 hour All these metric categories provide the following details:
Table 3–52 Configuration Parameters Metrics
Metric Description
Parameter Name Name of the configuration parameter. Default Value Default value assigned to this parameter. Memory Used Memory used by the parameter.
Config Value Most recent value to which the configuration parameter has been set with sp_ configure.
Run Value Value being used by Adaptive Server. It changes after you modify a parameter’s value with sp_configure and, for static parameters, after you restart Adaptive Server. Unit Unit of measurement. For example, bytes, number, and so on.
Type Indicates whether the parameter is dynamic or static. For static The Adaptive Server needs to be restarted if it is a static parameter. and not if it is a dynamic parameter.
Table 3–53 Database Instances Metrics
Metric Description
Data Space Utilization (%)
Name of the configuration parameter.
Free Data Space (MB) Default value assigned to this parameter. Free Log Space (MB) Memory used by the parameter.
Log Space Utilization
(%) Most recent value of the configuration parameter set by sp_configure. Total Data Space (MB) Value being used by Sybase Adaptive Server. It changes after you modify a
parameter's value with sp_configure and for static parameters, after you restart Sybase Adaptive Server.
Total Log Space (MB) Unit of measurement. For example, bytes, number, and so on.
Used Data Space(MB) Indicates whether the parameter is dynamic or static. For static parameters, Sybase Adaptive Server needs to be restarted. For dynamic parameter, it need not be started. Used Log Space (MB)