Foglight for Siebel 5.2.1 - User and Reference Guide

Chat now with support

Investigating Siebel Server performance Investigating Siebel component performance Investigating Siebel Server load Investigating Siebel component load Investigating Siebel Server SQL performance Investigating Siebel component SQL performance Investigating Siebel Server availability

Foglight for Siebel Systems Reference

SiebelServer Agent views

SiebelServer Agent rules

Sieb_Comp_AOMErrors rule Sieb_Comp_Inter_Task rule Sieb_Comp_Merge_Avail rule Sieb_Comp_MTServers rule Sieb_Comp_Proc_Avail rule Sieb_Comp_Route_Avail rule Sieb_Comp_Route_Task rule Sieb_Comp_State rule Sieb_Crash_Log rule Sieb_DB_Connect_Avail rule Sieb_GW_Connect_Avail rule Sieb_Log_Msg rule Sieb_Srvr_Avail rule Sieb_Srvr_CPU_Util rule Sieb_Srvr_Memory_Util rule Sieb_Srvr_NoDBConnRetry rule Sieb_Srvr_NoDLRbkRetry rule Sieb_Srvr_NoXhaustRetry rule Sieb_Srvr_Proc_CPUTime rule Sieb_Srvr_Proc_Memory rule Sieb_Task_Status rule

SiebelServer Agent data tables

Siebel Component Groups data table Siebel Component Statistics data table Siebel Components data table Siebel Log Message data table Siebel Process Information data table Siebel Server Health data table Siebel Server Statistics data table Siebel Server Summary data table Siebel Tasks data table

Siebel Server Health data table

The fields in this table are as follows:

Table 45. Siebel Server Health table information
Field	Description
DatabaseAlias	Database Name/Alias for the Siebel Enterprise. Value retrieved from agent properties.
DatabaseAvailability	Numeric value representing the Siebel server's ability to connect to the Siebel database (100 = True or zero = False).
EndTime	The time that a server is shut down. This value is only available when the server is shutdown within the Siebel Server Manager.
EnterpriseServer	Name of the Siebel enterprise that the Siebel server belongs to. Value retrieved from agent properties.
GatewayServer	Name of the gateway server for the Siebel enterprise. Value retrieved from agent properties.
GatewayServerAvailability	A value (100 = true and 0 = false) that indicates if the server can connect to the gateway server at the present time.
SiebelServer	The name of the Siebel server.
SiebelServerAvailability	A value (100 = running and zero = all other values) that represents the run state of the server.
SiebelServerPID	The operating system process id (PID) for the Siebel server.
SiebelServerStatus	The current state of the server. The possible status types include: Running, Shutdown, Unavailable, Login Failed, Handshake Failed, Not Available, Connect Failed, and Gateway Failure.
SiebelServerUpTime	The number of Days, Hours, Minutes and Seconds the Siebel Server is running.
StartTime	The time that the server started.

Siebel Server Statistics data table

The fields in this table are as follows:

Table 46. Siebel Server Statistics table information
Field	Description
AvgConnectTime	The average time that Object Manager sessions are connected since the last collection.
AvgReplySize	The average size (bytes) of reply messages since the last connection.
AvgRequestSize	The average size (bytes) of request messages since the last collection.
AvgResponseTime	The average Object Manager response time since the last collection.
AvgSQLExecTime	The average amount of time, in seconds, that the server spends performing SQL execute operations since the last collection.
AvgSQLFetchTime	The average amount of time, in seconds, that the server spends performing SQL fetch operations since the last collection.
AvgSQLParseTime	The average amount of time, in seconds, that the server spends performing SQL parse operations since the last collection.
AvgThinkTime	The average amount of end-user think time between requests since the last collection.
CPUTime	The total CPU time (seconds) for all the Siebel server’s tasks since the last collection.
ElapsedTime	Total elapsed or running time (seconds) for all the Siebel server’s tasks since the last collection.
NumberDBConnRetries	The number of retries resulting from database connection termination since the last collection.
NumberDLRbkRetries	The number of retries resulting from deadlock rollbacks since the last collection.
NumberExhaustedRetries	The number of times that retries have been exhausted since the last collection.
NumberReplyMessages	The number of reply messages sent by the server since the last collection.
NumberRequestMessages	The number of request messages sent by the server since the last collection.
NumberSQLExecutes	The number of SQL execute operations since the last collection.
NumberSQLFetches	The number of SQL fetch operations since the last collection.
NumberSQLParses	The number of SQL parse operations since the last collection.
NumberSleeps	The total number of sleeps for all tasks since the last collection.
SiebelServer	The name of the Siebel server.
SQLExecuteTime	The amount of time, in seconds, spent performing SQL execute operations since the last collection.
SQLFetchTime	The amount of time, in seconds, spent performing SQL fetch operations since the last collection.
SQLParseTime	The amount of time, in seconds, spent performing SQL parse operations since the last collection.
SleepTime	The total amount of time (seconds) for all the Siebel component’s tasks spent sleeping since the last collection.
Tasks	The total number of Siebel component tasks started since the last collection.
TotalAvgConnectTime	The average time the Object Manager sessions are connected since the Siebel server started.
TotalAvgRequestPerSession	The average number of requests per Object Manager session since the Siebel server started.
TotalAvgResponseTime	The average Object Manager response time since the Siebel server started.
TotalCPUTime	The total CPU time (seconds) for all the Siebel Server’s Tasks since the Siebel server started.
TotalReplySize	The total size, in bytes, of all reply messages since the last connection.
TotalRequestSize	The total size, in bytes, of all request messages since the last connection.
TotalResponseTime	The total response time, in seconds, for the Object Manager since the last connection.
TotalSQLExecuteTime	The total time (seconds) the Siebel server spent performing SQL execute operations since the Siebel server started.
TotalTasks	The total number of Siebel component tasks started since the Siebel server started.
TotalThinkTime	The total client think time, in seconds, or the total amount of elapsed time between client requests since the Siebel server started.

Siebel Server Summary data table

The fields in this table are as follows:

Table 47. Siebel Server Summary table information
Field	Description
SiebelServer	The name of the Siebel server.
TotalObjMgrSessions	The total number of Interactive tasks running on the Siebel server at the time of collection.
TotalPercentCPUTime	The total percentage of CPU time being used by all the Siebel processes at the time of collection.
TotalPercentMemory	The total percentage of resident set size used by all the Siebel processes at the time of collection.
TotalRunningTasks	The total number of tasks running on the Siebel server at the time of collection.

Siebel Tasks data table

The fields in this table are as follows:

Table 48. Siebel Tasks table information
Field	Description
ComponentAlias	A short name or alias for the Siebel component.
GroupAlias	A short name or alias for the Siebel component group associated with the component.
OSTaskPID	The operating system process id (PID) that is running this task.
TaskAvailability	A numeric value (100 = Running and zero = all other values) that represents the current task status.
TaskEndTime	The Mode the task is executed in (Background, Batch, or Interactive).
TaskID	A numeric identification code for the Siebel component task. This field is concatenated with the ComponentAlias field to create a unique identifier for the Component Event Log.
TaskRunMode	The current mode when the task is executed. The possible modes are Background, Batch, or Interactive.
TaskStartTime	The time that the task starts.
TaskStatus	The current status of the task. The status categories include Running, Paused, Stopping, Completed, Exited with Error, and Killed.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Foglight for Siebel 5.2.1 - User and Reference Guide

Siebel Server Health data table

Siebel Server Statistics data table

Siebel Server Summary data table

Siebel Tasks data table