Deployment Planning Guide > Data Integrity and Capacity Planning >

Sizing the Database for a Siebel Deployment

As with most client-server applications, the overall performance of Siebel eBusiness Applications is largely dependent on the I/O performance of the database server. To promote optimal I/O performance, it is critical that the tables and indexes in the database be arranged across available disk devices in a manner that evenly distributes the I/O load.

The mechanism for distributing database objects varies by RDBMS, depending on the way in which storage space is allocated. Most databases can force a given object to be created on a specific disk.

To verify which RDBMS products, versions, and patch levels are supported, see System Requirements and Supported Platforms on Siebel SupportWeb.

In your planning, you will need to allocate space for system storage, rollback or temporary storage space, log files, and other system files, as well as space for Siebel data and indexes. If you allocate too little space for your system, performance will be reduced. If you allocate too much, you will waste disk space.

The space needed by the RDBMS will vary primarily based on the total number and types of users supported, as well as the transaction mix and rate. Consult the RDBMS vendor's documentation for more information on these requirements.

The space required for Siebel data and indexes will vary depending on what Siebel eBusiness Applications functionality you will implement and the amount and nature of data supporting that functionality.

One database platform per Enterprise Server. The Siebel Servers in a Siebel Enterprise Server can connect to only one database. For example, you cannot configure both an Oracle and DB2 UDB database for use by the same Siebel Enterprise Server.

To determine the size of the database required for a Siebel deployment

1. Determine the total number and types of users of Siebel eBusiness Applications.

   For example, 500 sales representatives and 75 sales managers.

2. Determine the Siebel eBusiness Applications functionality that you will implement and the entities required to support them.

   Typically, the largest entities are as follows:

   • Accounts
   • Activities
   • Contacts
   • Forecasts
   • Opportunities
   • Service Requests
3. Estimate the average number of entities per user (for example, 100 accounts per sales representative) and calculate an estimated total number of records per entity for your total user base.
4. Using standard sizing procedures for your specific database, calculate the average record size per entity and multiply by the total number of records.

   Typically, these entities span multiple physical tables, all of which must be included in the row size calculation. This will determine the estimated data size for the largest entities.

5. Add additional space for the storage of other Siebel data.
   • A rough guideline for this additional amount would be half the storage required for these key entities.
   • Indexes typically require approximately the same amount of space as data.
6. Factor growth rates into your total size calculation.
7. Factor a margin of error into your total size calculation.