Part I: Simple Method

The Method:

Questions or comments ? Send a note to Kyle Hailey

What is different about this method as compared to many of the other tuning books and methods out there? The main thing is it is quick and easy. There is a clear starting point and a clear progression of what items that need to be verified. This is a clear path through the many hundresds of tables and values that one could possible check. This tuning method is for the production DBA maintaining an up and running system. This method is also good for the contractor or consultant who is spending a few days or weeks at a new site and needs to verify how the site is running and what recommendations and changes to make. One major difference in this method and other tuning methods is that it is reactive as oppose to proactive. Certainly proactive is the most important, but this method deals with what to do after the system has already been implemented and you are the DBA responsible for it.