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