Sybase Transactions Test

This test reports the transaction statistics of a Sybase database server.

Target of the test : A Sybase ASE (Below v15) server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for every Sybase server being monitored.

Configurable parameters for the test
Parameter Description

Test Period

How often should the test be executed.

Host

Refers to the IP address of the Sybase server.

Port

The port number at which the Sybase server listens to.

User

A Sybase user who has the “sa_role”.

Password

The password corresponding to the above user.

Confirm Password

Confirm the password by retyping it here.

Measurements made by the test
Measurement Description Measurement Unit Interpretation

Committed transactions

The rate of transaction commits

Trans/Sec

 

Rolledback transactions

The rate of transactions rollbacks

Trans/Sec

Rollbacks are costly operations on the database, and hence, will have to be kept at the minimum.

Inserts

The rate at which records are inserted into the database

Inserts/Sec

 

Updates

The rate at which records in the database are updated

Updates/Sec

 

Deletes

The rate at which records are deleted from the database

Deletes/Sec