Before you adjust your database server configuration, evaluate its performance with its current configuration.
If database applications perform well enough to satisfy user expectations, do not make frequent adjustments, even if those adjustments might produce a theoretical improvement in performance. Changing the database server configuration might interrupt users' work in an unexpected way. Altering some parameters requires you to bring down the database server. Adjusting the configuration to improve one aspect of performance might make performance worse in other ways.
As long as users are reasonably satisfied, take a gradual approach when you change the database server configuration. Make configuration changes in a test instance of the database server and evaluate the result before you change the configuration of your production system. However, some aspects of database server performance do not scale evenly from a small test instance to a large production instance.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]