|Bookshelf Home | Contents | Index | PDF|
To make sure that your database performs well, create at least one container for each available logical or physical disk device. You can use table spaces to place objects on multiple physical containers to promote parallel I/O. Spreading the data and index information across several containers (physical devices) can improve the performance of queries.
Data and log devices should reside on different disk spindles to reduce contention between random and serial I/O. All IBM DB2 devices should reside on different disk spindles to minimize I/O contention. When this approach is not possible, spread devices containing database objects that are often used together across different spindles. These objects include tables, their indexes, and commonly joined tables.
For UNIX database servers, all containers should reside on raw UNIX disk partitions, except the containers used for
Use filegroups for assigning database objects to one or more files within a filegroup for maximum performance of the Siebel Database. When you group objects, you have the ability to distribute a filegroup across multiple disks, thereby causing less resource contention.
If your enterprise does not require very high performance, based on the number of concurrent users, for example, using RAID devices and Microsoft's default setting may suffice. A database administrator must do the necessary sizing calculations to assess the performance requirements during the planning process.
|Siebel Deployment Planning Guide||Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.|