Go to primary content
Siebel CRM Performance Tuning Guide
Siebel Innovation Pack 2017
E24801-01
Home
Index
Next
View PDF
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 2017
What's New in Siebel Performance Tuning Guide, Siebel Innovation Pack 2016
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 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
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 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
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 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
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 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 Business Applications 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 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
Enabling and Configuring Siebel ARM
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