Contents

• Title and Copyright Information
• Preface
• 1 What's New in This Release
  • What's New in Siebel Performance Tuning Guide, Siebel CRM 19.7 Update
  • What's New in Siebel Performance Tuning Guide, Siebel CRM 19.1 Update
  • What's New in Siebel Performance Tuning Guide, Siebel 2018
• 2 Siebel CRM Architecture and Infrastructure
  • Siebel CRM 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
  • Sizing Considerations for Siebel CRM Version 17.0 and Later
• 3 Tuning the Siebel Application Object Manager for Performance
  • 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
  • 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
  • Tuning Siebel Web Client for Performance
  • About Siebel Web Clients
  • Performance Factors for Siebel Web Clients
    • About Supporting Multiple Siebel Modules
    • About Local Computer Resources
  • Guidelines for Siebel Web Client Tuning
    • Providing Sufficient Capacity for Siebel Application Interface and the Network
    • Testing Performance for Web Clients
    • Providing Sufficient Client Hardware Resources
    • Tuning System Components
    • Following Configuration Guidelines
    • Specifying Static File Caching on the Siebel Application Interface
    • Configuring the Data Block Size of HTTP Requests for the Siebel Developer Web Client
    • Managing Performance Related to Message Notification
• 6 Tuning Siebel Communications Server for Performance
  • 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
  • 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 CRM 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 Product Configurator for Performance
  • Tuning Siebel Product Configurator for Performance
  • Siebel Product Configurator Infrastructure
  • Performance Factors for Siebel Product Configurator
  • Topology Considerations for Siebel Product Configurator
    • Running Siebel Product Configurator in the Siebel Application Object Manager Component
    • Running Siebel Product Configurator on Dedicated Servers
      • Configuring Siebel Application Object Manager for Dedicated Siebel Product Configurator Deployments
  • Guidelines for Siebel Product Configurator Tuning
    • Tuning Siebel Product Configurator
    • Specifying the Siebel Product Configurator File System Location
    • Defining Customizable Product Models and Classes
  • About Siebel Product Configurator Caching
    • Default Caching Behavior for Siebel Product Configurator
    • Cache Management for Siebel Product Configurator
    • Parameters for Configuring Siebel Product Configurator Caching
    • Determining Rough Sizing for Caching Parameters
  • Administering the Siebel Product Configurator Cache
    • Refreshing the Entire Siebel Product Configurator Cache
    • Refreshing the Siebel Product Configurator Cache with Product Changes
    • Updating the Siebel Product Configurator Cache with Product Class Changes
    • Refreshing the Siebel Product Configurator Cache with Product Class Changes
    • Updating the Siebel Product Configurator Cache with Attribute Definition Changes
• 9 Tuning Siebel EAI for Performance
  • 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
  • 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 CRM
    • 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 a Siebel 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
  • 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 Siebel Mobile Web Client in a Siebel Remote Deployment
    • Optimizing Application Configuration File Parameters
      • DockTxnsPerCommit
    • Guidelines for Optimizing Data Synchronization Between Siebel Mobile Web Client and Siebel Remote
    • Choosing an Appropriate Routing Model
• 12 Tuning Customer Configurations for Performance
  • 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 a 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 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 Siebel Application Interface Computer for All Applicable UNIX and Linux Operating Systems
    • Configuring the Siebel Thread Stack Size on the Siebel Application Interface Computer
  • Tuning the Siebel Application Interface for All UNIX and Linux Operating Systems
  • Tuning Siebel CRM for AIX
    • Tuning the Siebel Server for AIX
    • Tuning Kernel Settings for AIX
  • Tuning Siebel CRM for HP-UX
    • Tuning Kernel Settings for HP-UX
    • Setting Permissions for the HP-UX Scheduler
  • Tuning Siebel CRM for Oracle Solaris
    • Tuning Kernel Settings for Oracle Solaris
    • Tuning Siebel Application Object Manager Instances for Oracle Solaris
• 14 Monitoring Siebel Application Performance with Siebel ARM
  • 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
  • Enabling and Configuring Siebel ARM
  • Guidelines for Converting Siebel ARM File
• 15 Analyzing Siebel ARM Data
  • 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 the 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