sybase Metrics

This article describes the metrics that can be configured using the sybase (Sybase Monitoring) probe.
uimpga-ga
This article describes the metrics that can be configured using the sybase (Sybase Monitoring)
probe.
The probe uses the following checkpoint metrics:
  • Count:
    Absolute number of events in the interval. It is calculated as delta between count at the beginning of the interval and at the end. In the first interval, counts are not checked because their interval value cannot be calculated. If there is a total value in the message, it means that the value is calculated since the start of the instance.
  • Gauge:
    Absolute number, describing the actual state of the system.
  • Ratio:
    Calculated percentage, using interval counts. In the first interval, it is calculated from total counts (as the interval count cannot be calculated).
  • Average:
    Calculated using interval counts. In the starting interval, it is calculated from absolute counts.
  • Status:
    Absolute value such as ONLINE and so on.
Contents
QoS Metrics
The following table describes the checkpoint metrics that can be configured using the sybase
probe.
Monitor Name
Units
Description
Version
QOS_SYBASE_CHECK_BSALIVE
Available
Displays the Sybase Backup Server connectivity
4.32
QOS_SYBASE_MONITOR_CONFIG
Percentage
Displays the cache usage statistics for metadata descriptors (such as index, objects, and database), reports statistics on auxiliary scan descriptors (such as referential integrity queries, and usage statistics for transaction descriptors) and DTX participants
4.32
QOS_SYBASE_DB_DEVICE_SIZE
Percentage
Displays the free Sybase database device size
4.32
QOS_SYBASE_LOG_SIZE
Percentage
Displays the free Sybase database log size
4.32
QOS_SYBASE_DATABASE_SIZE
Percentage
Displays the free Sybase database size free
4.32
QOS_SYBASE_DATABASE_SIZE_MB
Megabytes
Displays the free Sybase database size
4.32
QOS_SYBASE_DEVICE_SIZE
Percentage
Displays the free Sybase device size
4.32
QOS_SYBASE_LOCKED_USERS
Users
Displays a list of Sybase locked users
4.32
OS_SYBASE_LOGIN_COUNT
Users
Displays a list of currently logged users
4.32
QOS_SYBASE_SERVER_CPU
Percentage
Displays the Sybase server CPU usage
4.32
QOS_SYBASE_SERVER_IO
Percentage
Displays the Sybase server IO Busy
4.32
QOS_SYBASE_TEMPDB_DEVICE_SIZE
Percentage
Displays the free Sybase temporary database device size
4.32
QOS_SYBASE_ACTIVE_CONNECTION_RATIO
Percentage
Displays the Sybase active connection ratio
4.32
QOS_SYBASE_ACTIVE_USERS
Users
Displays the active Sybase users
4.32
QOS_SYBASE_CHECK_DBALIVE
Available
Displays the Sybase database connectivity
4.32
QOS_SYBASE_DEVICE_IO
Percentage
Displays Sybase device input and output busy status
4.32
QOS_SYBASE_LOCK_REQUESTS
Locks per second
Displays total Sybase lock requests
4.32
QOS_SYBASE_LOCK_REQUESTS_DB
Locks per second
Displays Sybase database lock requests
4.32
QOS_SYBASE_LOCK_REQUESTS_GRANTED_DB
Locks per second
Displays Sybase databse granted lock requests
4.32
QOS_SYBASE_LOCK_REQUESTS_WAITED_DB
Locks per second
Displays Sybase database waited lock requests
4.32
QOS_SYBASE_BUF_CACHEHIT_RATIO
Percentage
Displays the Sybase buffer cache hit ratio
4.32
QOS_SYBASE_DEAD_LOCKS
Deadlocks per second
Displays Sybase Dead-Locks
4.32
QOS_SYBASE_STP_CACHEHIT_RATIO
Percentage
Displays the Sybase Straight Through Platform cache hit ratio
4.32
*QOS_SYBASE_CHECK_MSALIVE
Available
Displays the Sybase MS connectivity
4.32
*QOS_SYBASE_PAGE_LOCKS
Locks
Displays Sybase Page-Locks
4.32
*QOS_SYBASE_TABLE_LOCKS
Locks
Displays Sybase Table-Locks
4.32
*QOS_SYBASE_LOG_CONTENTION
Contentions/sec
Displays Sybase log contentions
4.32
*QOS_SYBASE_TOTAL_MEMORY
Kb
Displays the total memory of the Sybase
4.32
*QOS_SYBASE_BUFFER_MEMORY
Kb
Displays the buffer cache memory of the Sybase
4.32
*QOS_SYBASE_STP_MEMORY
Kb
Displays the straight through platform cache memory of the Sybase
4.32
QOS_SYBASE_DATABASE_COUNT
Databases
Displays the active Sybase databases
4.32
QOS_SYBASE_TOTAL_DISK_IO
Operations per sec
Displays input and output operations of the entire Sybase server disk
4.32
QOS_SYBASE_TOTAL_DISK_READS
Reads per sec
Displays the entire Sybase server disk reads
4.32
QOS_SYBASE_TOTAL_DISK_WRITES
Writes per sec
Displays the entire Sybase server disk writes
4.32
*QOS_SYBASE_COMMITTED_TRANSACTIONS
Transactions/sec
Displays Sybase committed transactions
4.32
 The QoS names marked with an asterisk (*) are not applicable for the Linux 64-bit systems but are available on other platforms.
Alert Metrics Default Settings
This section contains the alert metric default settings for the sybase
probe.
Alert Metric
Warning Threshold
Warning Severity
Error Threshold
Error Severity
Description
active_connection_ratio
-
-
75
Major
Monitors the ratio of active to available connections
active_users
1
Warning
-
-
Monitors the number of active users
buf_cachehit_ratio
-
-
100
Major
Monitors the buffer cache-hit ratio
buffer_memory
128
Warning
-
-
Monitors the amount of buffer cache memory allocated by ASE server
check_bsalive
-
-
1
Major
Monitors connectivity to the backup server
check_dbalive
-
-
1
Major
Monitors connectivity to the database server
check_msalive
-
-
1
Major
Monitors connectivity to the monitor server
database_size
-
-
5
Major
Monitors free space (%) in the databases and the log-files
database_size_mb
-
-
10
Major
Monitors free space (MB) in the databases and the log-files
db_device_size
-
-
5
Major
Monitors free space (%) in database devices
dead_locks
1
Warning
-
-
Monitors the number of dead-locks per second in database
device_io
-
-
50
Major
Monitors % of device IO busy by the ASE Server in an interval
device_size
-
-
5
Major
Monitors free space (%) in devices
lock_requests
10
Warning
-
-
Monitors the total number of lock requests per second
lock_requests_db
1
Warning
-
-
Monitors the total number of lock requests per database per second
lock_requests_granted_db
1
Warning
-
-
Monitors the number of lock requests granted per database per second
lock_requests_waited_db
1
Warning
-
-
Monitors the number of lock requests waited per database per second
locked_users
4
Information
-
-
Monitors the number of locked users
log_contention
1
Warning
-
-
Monitors the number of total log contentions per sec
log_size
-
-
15
Major
Monitors free space (%) in the log-file of a database
login_count
1
Warning
-
-
Monitors the number of users currently logged onto the server
monitor_config
-
-
80
Major
Monitors level of static configuration parameter in %
page_locks
1
Warning
-
-
Monitors the number of page-locks in database
server_cpu
-
-
50
Major
Monitors % of CPU usage by the ASE Server in interval
server_io
-
-
30
Major
Monitors % of IO busy by the ASE Server in interval
server_startup
120
Information
-
-
Monitors the database uptime (in days)
stp_cachehit_ratio
-
-
75
Major
Monitor the stored procedure cache-hit ratio
stp_memory
128
Warning
-
-
Monitors the amount of stp cache memory allocated by ASE server
table_locks
1
Warning
-
-
Monitors the number of table-locks in database
tempdb_device_size
-
-
5
Major
Monitors free space (%) in temporary database devices
total_memory
512
Warning
-
-
Monitors the amount of memory allocated by ASE server
committed_transactions
Warning
-
-
Monitors the number of total committed transactions per second
database_count
4
Information
-
-
Monitors the number of active databases
total_disk_io
Warning
-
-
Monitors the total disk I/O operations per sec per device
total_disk_reads
Warning
-
-
Monitors the total number of disk reads per second
total_disk_writes
Warning
-
-
Monitors the total number of disk writes per second