Home | Previous Page | Next Page   Tuning Database Server Performance >

In This Chapter

This chapter provides information about how to tune the database server memory, I/O, and general resource use.

You tune the database server differently for DSS and OLTP applications. Because DSS applications are bandwidth intensive, you tune memory to increase the number of megabytes processed per second. Throughput-intensive OLTP applications require you to maximize I/O per second.

The same database server cannot provide optimum performance for both DSS and OLTP applications. If your database server hosts an operational data store (ODS) that is used by both OLTP-like and DSS-like applications, consider the various methods of adjusting performance for specific sessions, as described in Managing Resource Use for Specific Sessions. For additional information about tuning applications themselves, see Tuning Specific Queries and Transactions.

This chapter contains the following major sections:

Important:
Database server tuning cannot replace analysis and appropriate design of the databases and the database server configuration. For information about planning efficient hardware use, see Planning for Good Performance. For information about appropriate fragmentation, see Planning Table and Index Fragmentation.

For information about tuning the configuration parameter that determine virtual processor and CPU use, see Tuning CPU-Management Parameters.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]