This chapter provides information to help ensure that your database server can run your applications efficiently on the available hardware.
Before you configure a database server for good performance, efficient resource use, and easy maintenance, you first consider how client applications use the database server. Then you determine how to make the best use of all server resources. After you have performed this initial analysis, you can construct and test one or more database server configurations to help determine the optimal configuration for your production databases.
Consideration and analysis of the factors discussed in this chapter can help you plan:
The discussion focuses on analysis of your applications, patterns of use, and available hardware.
After the database server is configured and put into production, it is difficult, time consuming, and detrimental to users if you must make fundamental changes, particularly changes to the disk layout and database schemas. This chapter lists the aspects of the database server that you can adjust later without much interference with client applications and the aspects of the database server that are more disruptive.