Adaptive Server Statistics

The metrics in this category provide statistics about the ASE adaptive server.

Collection frequency - Every 30 minutes

Table 4-4 Adaptive Server Statistics Metrics

Metric	Description and User Action
For Release 6 Number of logins or attempted logins to SQL Server For Release 7 Attempted logins (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) The number of logins or attempted logins to the Server since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the logins or attempted logins were made to the Server, that is, the number of logins or attempted logins to the Server since last collection divided by the elapsed time between two collection.
Sybase ASE (Overall) CPU Utilization (%)	Overall CPU Utilization (%) of Sybase ASE.
Sybase ASE (Overall) IO Utilization (%)	Overall IO Utilization (%) of Sybase ASE.
For Release 6 Number of errors detected by SQL Server while reading and writing packets For Release 7 Detected packet (rcvd/sent) error rate (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) The number of errors detected by the server while reading and writing packets since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the errors were detected by the server while reading and writing packets since last collection, that is, the number of errors detected by the server while reading and writing packets since last collection divided by the elapsed time between two collection.
For Release 6 Number of input packets read by SQL Server For Release 7 Input packets read rate by AS (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) The number of input packets read by the server since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the input packets were read by the server since last collection, that is, the number of input packets read by the server since last collection divided by the elapsed time between two collection.
For Release 6 Number of output packets written by SQL Server For Release 7 Output packets write rate by AS (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) The number of output packets written by the server since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the output packets were written by the server since last collection, that is, the number of output packets written by the server since last collection divided by the elapsed time between two collection.
For Release 6 Number of connections handled since last collection	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) The number of connections handled since last collection.
For Release 6 Number of errors detected by SQL Server while reading and writing For Release 7 Detected disk read/write error rate (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) The number of errors detected by SQL Server while reading and writing since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which errors detected by the server while reading and writing since last collection, that is, the number of errors detected by the server while reading and writing divided by the elapsed time between two collection.
For Release 6 Number of disk reads by SQL Server For Release 7 Read rate from disk (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) The number of disk reads by the server since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the disk was read by the server since last collection, that is, number of disk reads by the server since last collection divided by the elapsed time between two collection.
For Release 6 Number of disk writes by SQL Server For Release 7 Write rate to disk (per sec)	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) The number of disk writes by the server since last collection. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) Rate at which the disk was written by the server since last collection, that is, the number of disk writes by the server since last collection divided by the elapsed time between two collection.

Metric

Description and User Action

For Release 6

Number of logins or attempted logins to SQL Server

For Release 7

Attempted logins (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

The number of logins or attempted logins to the Server since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the logins or attempted logins were made to the Server, that is, the number of logins or attempted logins to the Server since last collection divided by the elapsed time between two collection.

Sybase ASE (Overall) CPU Utilization (%)

Overall CPU Utilization (%) of Sybase ASE.

Sybase ASE (Overall) IO Utilization (%)

Overall IO Utilization (%) of Sybase ASE.

For Release 6

Number of errors detected by SQL Server while reading and writing packets

For Release 7

Detected packet (rcvd/sent) error rate (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

The number of errors detected by the server while reading and writing packets since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the errors were detected by the server while reading and writing packets since last collection, that is, the number of errors detected by the server while reading and writing packets since last collection divided by the elapsed time between two collection.

For Release 6

Number of input packets read by SQL Server

For Release 7

Input packets read rate by AS (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

The number of input packets read by the server since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the input packets were read by the server since last collection, that is, the number of input packets read by the server since last collection divided by the elapsed time between two collection.

For Release 6

Number of output packets written by SQL Server

For Release 7

Output packets write rate by AS (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

The number of output packets written by the server since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the output packets were written by the server since last collection, that is, the number of output packets written by the server since last collection divided by the elapsed time between two collection.

For Release 6

Number of connections handled since last collection

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

The number of connections handled since last collection.

For Release 6

Number of errors detected by SQL Server while reading and writing

For Release 7

Detected disk read/write error rate (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

The number of errors detected by SQL Server while reading and writing since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which errors detected by the server while reading and writing since last collection, that is, the number of errors detected by the server while reading and writing divided by the elapsed time between two collection.

For Release 6

Number of disk reads by SQL Server

For Release 7

Read rate from disk (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

The number of disk reads by the server since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the disk was read by the server since last collection, that is, number of disk reads by the server since last collection divided by the elapsed time between two collection.

For Release 6

Number of disk writes by SQL Server

For Release 7

Write rate to disk (per sec)

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0)

The number of disk writes by the server since last collection.

For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0)

Rate at which the disk was written by the server since last collection, that is, the number of disk writes by the server since last collection divided by the elapsed time between two collection.