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