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.
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. |
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 |
|