Siebel Database Test

This test monitors the overall health of the interactions between the Siebel Application server and its backend database.

Target of the test : A Siebel Application Server

Agent deploying the test : A remote agent

Outputs of the test : One set of results for each Siebel server being monitored.

Configurable parameters for the test
Parameter Description

Test period

How often should the test be executed

Host

The host for which the test is to be configured.

Port

The port number at which the specified host listens to. By default, this is 1199.

JMX Remote Port

Specify the port at which the JMX listens for requests from the remote hosts. Ensure that you specify the same port that you have mentioned in the agentconfig.connectors.xml file in the <SIEBEL_INSTALL_DIR>\siebsrvr\mgmtagent\pref\system folder used in the target application.

JNDIName

The JNDIName is a lookup name for connecting to the JMX connector. By default, this is jmxrmi. If you have resgistered the JMX connector in the RMI registery using a different lookup name, then you can change this default value to reflect the same.

Siebel Agent User and Siebel Agent Password

In order to monitor the Siebel Application server, a valid user possessing admin privileges is required. Specify the login credentials of such a user in the Siebel Agent User and Siebel Agent Password text boxes.

Confirm Password

Confirm the Siebel Agent Password by retyping it here.

Measurements made by the test
Measurement Description Measurement Unit Interpretation

Average sql execute time

Indicates the average time taken for SQL execute operations.

Secs

 

Average sql fetch time

Indicates the average time taken for SQL fetch operations.

Secs

 

Average sql parse time

Indicates the average time taken for SQL parse operations.

Secs

 

Sql executes

Indicates the total number of execute operations per second.

Executes/Sec

 

Sql fetches

Indicates the total number of SQL fetch operations per second.

Fetches/Sec

A low value is indicative of low fetch- intensive Siebel queries on the Siebel database.

Sql parses

Indicates the total number of SQL parse operations per second.

Parses/Sec

A low value is indicative of low parse- intensive queries on the Siebel database.