Sybase DatabaseStats Test

This test is used to track the memory usage, backup state, transaction log space requests, and wait statistics of each database. For this test to work, make sure that the enable monitoring parameter is enabled.

Target of the test : A Sybase ASE server on which the MDA tables have been installed

Agent deploying the test : An internal agent

Outputs of the test : One set of results for every Sybase ASE 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 ASE server.
Port	The port number at which the Sybase server listens to.
User	To enable this test to connect to the Sybase server and collect the required metrics, it is enough if you configure the test with the name of a Sybase user who has the “mon_role”. However, for best results, it is recommended that you configure all Sybase tests with the credentials of a Sybase user who has the “mon_role”, “sa_role’, and “sybase_ts_role”.
Password	The password corresponding to the above user
Confirm Password	Confirm the password by retyping it here.
Detailed Diagnosis	To make diagnosis more efficient and accurate, the eG Enterprise embeds an optional detailed diagnostic capability. With this capability, the eG agents can be configured to run detailed, more elaborate tests as and when specific problems are detected. To enable the detailed diagnosis capability of this test for a particular server, choose the On option. To disable the capability, click on the Off option. The option to selectively enable/disable the detailed diagnosis capability will be available only if the following conditions are fulfilled: The eG manager license should allow the detailed diagnosis capability Both the normal and abnormal frequencies configured for the detailed diagnosis measures should not be 0.

Measurements made by the test
Measurement	Description	Measurement Unit	Interpretation
Used memory	The memory currently used by each database	MB	Ideally, the value of this measure should be low. In the event of a sudden slowdown in the performance of the Sybase server, you might want to compare the memory usage of all databases on the server to identify which database is excessively consuming memory resources.
Last backup state	Whether the last backup succeeded or failed.	Number	If the value of this measurement is ‘1’, then it indicates that the last backup you attempted or scheduled failed. You would then have to investigate the reasons for the failure and rectify them. If the last backup was successful, then this measure will return the value ‘0’.
Transaction log state	The current status of transaction log gets.	Number	If this measurement is ‘1’, it implies that the transaction log of that database has run out of space. When this occurs, you would have to allocate more space for that transaction log file; if not, database performance will suffer.
Append log request	The number of times the Sybase server placed a request for log space for that database.	Number
Append log waits	The current number of log requests waiting to be processed.	Number	If most of the Append log requests are in waiting – i.e., if the value of this measure is dangerously close to that of the Append log requests measure- it could indicate a processing bottleneck on the server; this is typically caused by insufficient space in the transaction logs. In such a situation, it would be best to allocate more space to the transaction log, so that the request queue length reduces.