Bookshelf Home | Contents | Index | PDF |
Siebel Deployment Planning Guide > Data Integrity and Capacity Planning > Database Physical Device PlanningTo 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 input and output (I/O). Spreading the data and index information across several containers (physical devices) can improve the performance of queries. IBM DB2 Physical Device PlanningLocate data and log devices on different disk spindles to reduce contention between random and serial I/O. For IBM DB2, locate these devices 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. If you are using a high performance disk subsystem, then you might choose a different physical device layout. Consult your DBA and the disk subsystem vendor for the optimal setup. Physical Device Planning for UNIX DeploymentsFor UNIX database servers, locate all of the containers on raw UNIX disk partitions, except the containers used for Microsoft SQL Server Physical Device PlanningUse 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, then using RAID devices and Microsoft's default setting might suffice. A database administrator must do the necessary sizing calculations to assess the performance requirements during the planning process. |
Siebel Deployment Planning Guide | Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |