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