Sybase System Processes Test

This test reports details about the system processes running in 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.
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
Sybase processes	The total number of Sybase processes	Number
Background processes	The total number of background processes run by the Adaptive Server rather than by a user process	Number	The detailed diagnosis of this measure, if enabled, provides the details pertaining to the background processes currently executing.
Running processes	The total number of running processes	Number	The detailed diagnosis of this measure, if enabled, provides details such as the ID of the running processes, the user executing each of the processes, the database on which every process is executing etc.
Sleeping processes	The total number of sleeping processes	Number	The detailed diagnosis of this measure, if enabled, provides details such as the ID of the sleeping processes, the user executing each of the processes, the database on which every process is executing, the sleep status, sleep time etc.
Infected processes	The total number of processes in which the server has detected a serious error condition	Number	The detailed diagnosis of this measure, if enabled, provides the ID of the infected processes, the user executing each of the processes, and the database on which every process is executing. This information enables the user to isolate the specific queries that are infected. Further analysis of these queries can be performed, in order to figure out the reason for the infection and take adequate measures to prevent it from recurring.
Blocked processes	If a process attempts to access a resource that is already in use by another process, then such a process will be blocked until such time that the other process releases the resource. This measures indicates the total number of blocked processes.	Number	The detailed diagnosis of this measure, if enabled, reveals information such as the ID of the blocked processes, the user executing each of the processes, the database on which every process is executing, the waiting time of the blocked process, etc.