Bookshelf Home | Contents | Index | Search | PDF |
Siebel Server Installation Guide for Microsoft Windows > Creating the Microsoft SQL Server Database > Database Layout Guidelines >
Planning the Distribution of Your Database Objects
Regardless of your chosen disk arrangement, be sure that you properly distribute the following types of database objects:
- Database log
- Temporary work space used by the database
- Tables and indexes
In most implementations, the tables and corresponding indexes in the following list of tables tend to be the either the most heavily used, or they have the potential to be large in some or in all deployments. The tables
S_EVT_ACT, S_CONTACT
andS_ORG_EXT
are large in all large deployments of Siebel eBusiness Applications.Table 25 should be separated across devices, and the log should be on a separate disk.
If you will make frequent use of Siebel Enterprise Integration Manager (EIM), you may want to put the interface tables (names starting with
EIM_
) in different filegroups as well as separate disk arrays from the Siebel base tables, because both are accessed simultaneously during EIM operations.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Server Installation Guide for Microsoft Windows Published: 25 June 2003 |