Chat now with support
Chat with Support

Foglight for Siebel 5.2.1 - User and Reference Guide

Introducing Foglight for Siebel Systems Foglight for Siebel Systems Summary Dashboard About the Foglight SiebelServer Agent Foglight for Siebel Systems Reference

Investigating Siebel Server load

The Siebel eBusiness application environment typically includes multiple Siebel servers with each Siebel server being assigned multiple Siebel components. It is important that all the Siebel servers that include the Siebel enterprise share the load and one or more Siebel servers are not overutilized while others in the enterprise remain underutilized.
The Foglight SiebelServer Agent collects statistics to enable the Siebel administrator the ability to correlate the Siebel server’s response time, utilization, and throughput.
To start with the Sieb_Srvr_Utilization_Overview graph view:
•
Open the Sieb_Srvr_Utilization_Overview graph view which provides information about object manager response time, resource utilization, and the number of running and interactive tasks.

Investigating Siebel component load

If the Siebel administrator suspects that a Siebel server is overloaded, an analysis of each operating system process that includes the Siebel server should be performed.
The Foglight SiebelServer Agent calculates CPU and memory utilization statistics for each operating system process that includes the Siebel server. For Siebel 7 enterprises, this agent is able to correlate the siebmtsh executables that run multi threaded processes or MTServers with the corresponding Siebel component. There is one siebmtsh executable for each MTServer that is running.
Even though the Foglight SiebelServer Agent calculates CPU and memory utilization statistics for each operating system process, the agent uses the Number of Top Siebel OS Process to Monitor agent property value to determine the number of top processes to store in the Foglight repository for each collection. Foglight sorts by memory percentage when determining the top processes to store in the Foglight repository.
To start with the Sieb_Proc_Utilization graph view:
•
Open the Sieb_Proc_Utilization graph view which monitors CPU and memory resource usage.

Investigating Siebel Server SQL performance

When a Siebel task is completed, task level statistics gathered dynamically during the operation of a task roll up to the component level. Statistics for all enabled components assigned to a Siebel server are rolled up to the Siebel server level. Siebel server statistics are cumulative, that is, since the Siebel server started. Among the many statistics that are gathered and rolled up to the Siebel server leve,l are statistics on the time that the Siebel server has spent parsing, running, and fetching SQL statements.
Siebel Support Web provides the following SQL time definitions:
•
SQL Parse Time. The number of seconds spent translating the SQL statements into an execution plan. This time includes checking for proper security authorization and checks for the existence of tables, columns, and other referenced objects.
•
SQL Execute Time. For SELECT statements, the amount of time spent identifying the rows if the statement requires a sort or uses FOR UPDATE. For INSERT, UPDATE, and DELETE statements, the amount of time spent modifying the data.
•
SQL Fetch Time. For SELECT statements only, the amount of time spent retrieving the rows that the query returns.
The Foglight SiebelServer Agent collects delta SQL parse, SQL execute, and SQL fetch statistics for the Siebel server. Foglight calculates the deltas by determining the change in the individual statistic since the last collection and stores the delta value in the Foglight repository. This allows the Siebel administrator to identify peak SQL usage time periods.
To start with the Sieb_Srvr_SQLTime graph view:
•
Open the Sieb_Srvr_SQLTime graph view which monitors SQL parse, fetch, and execute collection times.

Investigating Siebel component SQL performance

When a Siebel task completes its operation, task level statistics gathered dynamically during the operation of each task, roll up to the component level. Among the statistics gathered and rolled up to the Siebel component level are statistics on the time that the Siebel component spent parsing, executing, and fetching SQL statements. Siebel server statistics are cumulative, that is, since the Siebel server started.
The Foglight SiebelServer Agent collects delta SQL parse, execute, and fetch statistics for each enabled Siebel component. Foglight calculates the deltas by determining the change in the individual cumulative statistic since the last collection and stores the delta value in the Foglight repository. This allows the Siebel administrator to identify peak SQL usage time periods for each Siebel component.
To start with the Sieb_Comp_SQLTime graph view:
•
Open the Sieb_Comp_SQLTime graph view which tracks the amount of time spent translating, identifying, and retrieving SQL statements.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating