Overview: Siebel eBusiness Application Integration Volume I > Scalability and Performance > EAI Siebel Adapter Performance >

SQL Produced by the EAI Siebel Adapter

Requests to the EAI Siebel Adapter eventually generate SQL to be executed against the relational database storing the Siebel Server's data. By setting the event SQL to level 4 in the component running in the EAI Siebel Adapter, you can get a trace of the SQLs being executed along with timings for each statement. You can get timings for each of the EAI Siebel Adapter operations by setting the event EAISiebAdptPerf to 4. This can be used to correlate the EAI Siebel Adapter calls with their associated SQL.

After you have this information, look through the logs to find any SQL statements taking significantly longer than average. To improve the performance of such statements, look at the BusComp definition (perhaps eliminating unnecessary joins and fields) or at the physical database schema (perhaps adding indexes).


 Overview: Siebel eBusiness Application Integration Volume I 
 Published: 18 April 2003