Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Documentation Accessibility
• Related Documents
• Conventions

1 What's New in This Release

• What's New in Siebel Performance Tuning Guide, Siebel Innovation Pack 2015, Rev. A
• What's New in Siebel Performance Tuning Guide, Siebel Innovation Pack 2015
• What's New in Siebel Performance Tuning Guide, Siebel Innovation Pack 2014

2 Siebel Architecture and Infrastructure

• About Performance and Scalability
• About Siebel Architecture and Infrastructure
  • Siebel Architecture and Infrastructure Areas for Tuning
• About Siebel User Request Flow
• Performance Tuning Terminology

3 Tuning the Siebel Application Object Manager for Performance

• About the Siebel Application Object Manager
• Siebel Application Object Manager Infrastructure
  • Siebel Application Object Manager Communications with Other Modules
  • About Tuning the Siebel Application Object Manager
• Performance Factors for Siebel Application Object Manager Deployments
  • Concurrent Users
  • Think Time
  • Nature of Siebel Application Deployment
  • Hardware Resources
• Topology Considerations for Siebel Application Object Manager Deployments
• Guidelines for Siebel Application Object Manager Tuning
  • Tuning Siebel Application Object Manager Components for CPU and Memory Utilization
    • About MaxTasks, MaxMTServers, and MinMTServers
    • Effect of Siebel Application Object Manager Parameter Settings
    • Guidelines for Configuring Siebel Application Object Manager Parameters
    • Formulas for Calculating Siebel Application Object Manager Parameter Values
    • Example Settings for Siebel Application Object Manager Parameters
  • Tuning Parameters for Siebel Application Object Manager Caches
    • SQL Cursor Cache
    • SQL Data Caches
  • Additional Parameters Affecting Siebel Application Object Manager Performance
  • Memory Consumers in Siebel Application Object Manager
• Configuring Database Connection Pooling for Siebel Application Object Managers
  • About Database Connections for Siebel Application Object Managers
    • About Nonpooled Database Connections
    • About Pooled Database Connections
  • Database Connection Pooling Usage Guidelines
    • When to Consider Using Database Connection Pooling
    • Guidelines for Using Database Connection Pooling
  • Configuring Pooling for Default Database Connections
    • Configuring Parameters for Pooling Default Connections
    • Example Configuration for Pooling Default Connections
    • How Pooled Default Connections Are Assigned
  • Configuring Pooling for Specialized Database Connections
    • Configuring Parameters for Pooling Specialized Connections
    • Scenario for Assigning Pooled Specialized Connections
• Using Thread Pooling for Siebel Application Object Managers
  • About Thread Pooling for Siebel Application Object Manager
  • Configuring Siebel Application Object Manager Thread Pooling

4 Tuning the Siebel Server Infrastructure for Performance

• Configuring SISNAPI Connection Pooling for Siebel Application Object Managers
• Tuning Server Request Broker (SRBroker)
  • About Synchronous and Asynchronous Requests Forwarded by SRBroker to Batch Components

5 Tuning Siebel Web Client for Performance

• About Siebel Clients
• Performance Factors for Siebel Web Clients
  • About Supporting Multiple Siebel Modules
  • About Local Computer Resources
• Guidelines for Siebel Web Client Tuning
  • Providing Sufficient Web Server and Network Capacity
  • Testing Performance for Web Clients
  • Providing Sufficient Client Hardware Resources
  • Tuning System Components
  • Following Configuration Guidelines
  • Managing the Browser Cache
  • Specifying Static File Caching
    • Static File Caching for Microsoft IIS
    • Static File Caching for an Apache Web Server
    • Static File Caching for Oracle iPlanet Web Server
  • Improving Performance Using View Layout Caching
    • View Layout Caching in Memory
    • Setting the View Cache Size
    • Persistent View Layout Caching
    • Preloading Cached Views into Memory
    • Disabling View Layout Caching
    • Determining How the Current View Layout Was Loaded
    • Determining Whether Views Are Available for Layout Caching
  • Configuring the Data Block Size of HTTP Requests for the Siebel Developer Web Client
  • Managing Performance Related to Message Broadcasting
  • Configuring the Busy Cursor for Standard Interactivity Applications

6 Tuning Siebel Communications Server for Performance

• About Siebel Communications Server
• Session Communications Infrastructure
  • Key Siebel Server Components
  • Other Siebel Server Components
  • Third-Party Product Modules
• Performance Factors for Session Communications
  • Third-Party Product Considerations
• Topology Considerations for Session Communications
  • Running CommSessionMgr on Siebel Application Object Manager Computers
  • Running CommSessionMgr on Dedicated Computers
• Guidelines for Session Communications Tuning
  • Tuning the Siebel Application Object Manager Component
  • Tuning the CommSessionMgr Component
  • Conserving Siebel Application Object Manager Server Resources Through Caching
  • Improving Performance for Communications Configurations
  • Configuring Logging for Session Communications
    • Siebel Application Object Manager Logging Parameters
    • CommSessionMgr Logging Parameters
  • Improving Availability for Session Connections
  • Improving Screen Pop Performance
  • Reviewing Performance Impact of Activity Creation
• Siebel Email Response Infrastructure
  • Key Server Components
  • Other Siebel Components or Modules
  • Third-Party Email Server
• Performance Factors for Siebel Email Response
• Topology Considerations for Siebel Email Response
• Guidelines for Siebel Email Response Tuning
  • Configuring CommInboundRcvr Threads
  • Managing Email Processing Directories
  • Reviewing Performance Impact of Activity Creation
  • Configuring Logging for Siebel Email Response

7 Tuning Siebel Workflow for Performance

• About Siebel Workflow
• Monitoring Workflow Policies
  • Using the Policy Frequency Analysis View
  • Using Workflow Agent Trace Files
  • Monitoring Workflow Policies Tables
• Tuning Workflow Policies for Performance
  • Creating Workflow Policy Groups to Manage Siebel Server Load
  • Multiple Workflow Monitor Agents and Workflow Action Agents
  • Running Workflow Agents on Multiple Siebel Servers
  • Setting Optimal Sleep Interval for Workflow Policy Groups
  • Setting Optimal Action Interval for Workflow Monitor Agent and Workflow Action Agent
• Tuning Workflow Processes
  • Minimizing Usage of Parameter Search Specification
    • Indexing Fields in SearchSpec
  • Monitoring Conditions Based on Parent and Child Business Components
  • Configuring Siebel Business Applications for Workflow Performance
  • Monitoring Memory Overhead for Workflow Processes
    • Running Workflows Locally in Siebel Application Object Manager
    • Running Workflows in Workflow Process Manager
    • About Asynchronous Mode for Workflow Process Requests
• Tuning Workflow Process Manager for Performance
  • Caching Business Services
  • Caching Sessions

8 Tuning Siebel Configurator for Performance

• Siebel Configurator Infrastructure
• Performance Factors for Siebel Configurator
• Considerations for Defining Topology for Siebel Configurator
  • Running Siebel Configurator in the Siebel Application Object Manager Component
  • Running Siebel Configurator on Dedicated Servers
    • Configuring Siebel Application Object Manager for Dedicated Siebel Configurator Deployments
• Guidelines for Siebel Configurator Tuning
  • Tuning Siebel Configurator
  • Specifying the Siebel Configurator File System Location
  • Defining Customizable Product Models and Classes
• About Siebel Configurator Caching
  • Default Caching Behavior for Siebel Configurator
  • Cache Management for Siebel Configurator
  • Parameters for Configuring Siebel Configurator Caching
  • Determining Rough Sizing for Caching Parameters
• Administering the Siebel Configurator Cache
  • Refreshing the Entire Siebel Configurator Cache
  • Refreshing the Siebel Configurator Cache with Product Changes
  • Updating the Siebel Configurator Cache with Product Class Changes
  • Refreshing the Siebel Configurator Cache with Product Class Changes
  • Updating the Siebel Configurator Cache with Attribute Definition Changes

9 Tuning Siebel EAI for Performance

• About Siebel Enterprise Application Integration
• Guidelines for Siebel EAI Tuning
  • Improving IBM WebSphere MQ Transport Performance
    • Inbound Messages
    • Outbound Messages (Send, SendReceive)
    • Performance Events
  • Improving HTTP Inbound Transport Performance
  • EAI Siebel Adapter Performance
    • Reviewing Scripting
    • Disabling Logging
    • Minimizing Integration Object Size
    • Analyzing SQL Produced by EAI Siebel Adapter
    • Running EAI Siebel Adapter in Parallel
    • Caching Business Objects
  • Virtual Business Component Performance
  • Improving Workflow Process Manager Performance
    • CPU and Memory Consumption
    • Performance Events
  • Other Guidelines for Siebel EAI

10 Tuning Siebel EIM for Performance

• About Siebel EIM
• Siebel EIM Architecture Planning Requirements
  • Database Sizing Guidelines
  • Database Layout Guidelines (Logical and Physical)
• Siebel EIM Usage Planning
  • Defining the Siebel EIM Team
  • Mapping Data into Siebel Business Applications
  • Testing Siebel EIM Processes
• General Guidelines for Optimizing Siebel EIM
• Recommended Sequence for Implementing Siebel EIM Processes
  • Optimizing the .IFB File for Siebel EIM
  • Checking .IFB File Optimization for Siebel EIM
  • Separating Siebel EIM Processes by Operation
• Troubleshooting Siebel EIM Performance
  • Optimizing SQL for Siebel EIM
  • Using the USE INDEX HINTS and USE ESSENTIAL INDEX HINTS Parameters
  • Using USE INDEX HINTS and USE ESSENTIAL INDEX HINTS: Example
    • With Hints
    • Without Hints
  • Using USE INDEX HINTS and USE ESSENTIAL INDEX HINTS: Criteria for Passing Indexes to the Database
  • Using the SQLPROFILE Parameter
    • SQL Statements
  • Additional Indexes on Siebel EIM Tables
    • Adding Indexes to Improve Performance of S_ORG_EXT Table
  • Creating Proper Statistics on Siebel EIM Tables
    • IBM DB2 Options
  • Dropping Indexes in Initial Runs of Siebel EIM
  • Controlling the Size of Batches for Siebel EIM
    • Recommended Number of Rows for a Single Batch
  • Controlling the Number of Records in Siebel EIM Tables
  • Using the USING SYNONYMS Parameter with Siebel EIM
  • Using the NUM_IFTABLE_LOAD_CUTOFF Extended Parameter with Siebel EIM
  • Disabling Transaction Logging for Siebel EIM
  • Disabling Database Triggers for Siebel EIM
  • Running Siebel EIM Tasks in Parallel
• Database Guidelines for Optimizing Siebel EIM
  • Microsoft SQL Server and Siebel EIM
    • Fixing Table Fragmentation
    • Purging an EIM Table
    • Parallel Data Load for EIM tables Using bcp
    • TempDB
    • Configuration Parameters
  • Oracle Database and Siebel EIM
    • Avoiding Excessive Table Fragmentation
    • Purging an EIM Table
    • Disabling Archive Logging
    • FREELIST Parameter
    • Caching Tables
    • Updating Tables
  • IBM DB2 and Siebel EIM
  • IBM DB2 for z/OS and Siebel EIM
  • IBM DB2 for z/OS Loading Process for Siebel EIM
  • General Recommendations for the IBM DB2 for z/OS Loading Process
• Data Management Guidelines for Optimizing Siebel EIM
• Run Parameter Guidelines for Optimizing Siebel EIM
• Monitoring the Siebel Server During a Siebel EIM Task

11 Tuning Siebel Remote for Performance

• About Siebel Remote
• Tuning Siebel Remote Server Components
  • Increasing Throughput for the Database Extract and Parallel Database Extract Components
  • Tuning the Transaction Router Component
    • Visibility-Related Transactions
    • Docking Rules and Data Distribution
    • Slow-Running Queries
    • Increasing Transaction Router Throughput
    • Setting the Id Db Size Parameter
• Tuning the Mobile Web Client in a Siebel Remote Deployment
  • Optimizing Application Configuration File Parameters
    • DockTxnsPerCommit
    • AutoStopDB
    • Allocating Memory to the SQL Anywhere Database Engine Cache
    • Sort Collation
  • Guidelines for Optimizing Data Synchronization Between Siebel Mobile Web Client and Siebel Remote
  • Choosing an Appropriate Routing Model

12 Tuning Customer Configurations for Performance

• General Performance Guidelines for Customer Configurations
• Analyzing Generated SQL for Performance Issues
  • About Specifying SQL Logging and SQL Tagging for Siebel Application Object Manager Components
  • Troubleshooting Poor Performing SQL at the Database Level Using Workload Tagging
    • About Enabling and Disabling Workload Tagging
    • Requirements for Enabling and Disabling Workload Tagging
    • Enabling and Disabling Workload Tagging Using the Siebel Application
    • Enabling and Disabling Workload Tagging Using the Siebel Server Manager
    • Using Workload Tagging to Troubleshoot Poor Performing SQL at the Database Level
  • Specifying SQL Spooling in Siebel Developer Web Client
  • Troubleshooting Performance Using SQL Trace Files
  • Troubleshooting Performance Using SQL Query Plans
  • Example of Obtaining Query Plan
  • SQL Queries Against Database Data
• Guidelines for Siebel Scripting
  • Using Declarative Alternatives to Siebel Scripting
  • Siebel Scripting Guidelines for Optimal Performance
• Guidelines for Data Objects Layer
  • Multilingual LOVs Query and Cache Performance
  • Managing Database Indexes in Sorting and Searching
    • Sort Specification
    • Search Specification
  • Reusing Standard Columns
    • Example: Reusing NAME and LOC in S_ORG_EXT Table
    • Query Plan for My Accounts View
    • Query Plan for My Accounts View (Different ORDER BY Clause)
  • Limiting Extension Columns
  • Case Insensitivity and Performance
• Guidelines for Business Objects Layer
  • Using the Cache Data Property to Improve Business Component Performance
  • Limiting the Number of Active Fields
  • Guidelines for Using Calculated Fields
  • Using Properties to Improve Picklist Performance
  • Using Primary ID Fields to Improve Performance
  • How the Check No Match Property Impacts Performance
• Guidelines for User Interface Objects Layer
  • Addressing Performance Issues Related to Grid Layout
  • Maintaining Performance When Using Applet Toggles

13 Tuning Operating Systems for Performance

• Tuning Microsoft Windows for Enhanced Siebel Server Performance
  • Maximizing Data Throughput
  • Turning on the 4GT RAM Tuning Feature
• Tuning the Siebel Server for All UNIX and Linux Operating Systems
  • Environment Variable for Siebel Assert Creation
  • Environment Variable for Operating System Resource Limits
  • Environment Variables for Operating System Latches
• Tuning the Web Server Computer for All Applicable UNIX and Linux Operating Systems
  • Configuring the Siebel Thread Stack Size on the Web Server Computer, for All Web Servers Except Oracle HTTP Server
  • Configuring the Siebel Thread Stack Size on the Web Server Computer, for Oracle HTTP Server
• Tuning the Siebel Web Server Extension for All UNIX and Linux Operating Systems
• Tuning an Apache Web Server for Applicable UNIX and Linux Operating Systems
• Tuning Siebel Business Applications for AIX
  • Tuning the IBM HTTP Server for AIX
  • Tuning the Siebel Server for AIX
  • Tuning Kernel Settings for AIX
• Tuning Siebel Business Applications for HP-UX
  • Tuning Kernel Settings for HP-UX
  • Setting Permissions for the HP-UX Scheduler
• Tuning Siebel Business Applications for Oracle Solaris
  • Tuning the Oracle iPlanet Web Server
  • Tuning Kernel Settings for Oracle Solaris
  • Tuning Siebel Application Object Manager Instances for Oracle Solaris

14 Monitoring Siebel Application Performance with Siebel ARM

• About Siebel Application Response Measurement
• About Siebel ARM Parameters and Variables
  • SARM Granularity Level
  • SARM Buffer Size
  • SARM Period
  • SARM Max Number of Files
  • SARM Data File Size
  • SIEBEL_SARMThreshold Environment Variable
• Enabling and Configuring Siebel ARM
  • Setting Siebel ARM Parameters on the Siebel Server
  • Setting Siebel ARM Environment Variables on the Web Server
• Guidelines for Converting Siebel ARM File

15 Analyzing Siebel ARM Data

• About Siebel ARM Files
• Analyzing Siebel ARM Files Using the Siebel ARM Query Tool
  • About the Siebel ARM Query Tool
    • Comparison with Siebel ARM Analyzer Tool
    • Summary of Features of the Siebel ARM Query Tool
  • General Commands for the Siebel ARM Query Tool
  • Configuring the Siebel ARM Query Tool
  • Configuring Input for the Siebel ARM Query Tool
  • Configuring Output from the Siebel ARM Query Tool
  • Using Selection Filters with the Siebel ARM Query Tool
  • Aggregating Siebel ARM Data with the Siebel ARM Query Tool
  • Generating Histograms with the Siebel ARM Query Tool
  • Using Macros with the Siebel ARM Query Tool
• Analyzing Siebel ARM Files Using the Siebel ARM Analyzer Tool
  • About Siebel ARM Analyzer Tool
  • Running Performance Aggregation Analysis
  • Running Call Graph Generation
  • Running User Session Trace
  • Running Siebel ARM Data CSV Conversion
  • About Siebel ARM Analyzer Output Files
  • About Performance Aggregation Analysis and Data
  • About Call Graph Generation Analysis and Data
  • About User Session Trace Analysis and Data
  • About Siebel ARM to CSV Conversion Data

Index