METHOD AND APPARATUS FOR ENHANCING PERFORMANCE OF DATABASE AND ENVIRONMENT THEREOF

A method and apparatus for enhancing the performance of an environment comprising a database system. The method and apparatus employ collection stage for collecting data related to substantially all aspects of the system, including hardware, operating system, database, database schema, content and activity. Multiple issues relating to multiple categories are detected within the collected information. Then the detected issues are analyzed by correlating and prioritizing them. The issues that receive the highest priority are preferably those whose correction will yield the most significant improvement on the overall performance of the system. One or more recommendations are then issued for correcting the root issues hindering performance. Preferably, for one or more recommendations, scripts are generated which are then executed manually or automatically.