6. The computer-controlled method of claim 1 , wherein gathering information comprises pulling data from a history instance and a snapshot instance.
1. A computer-controlled method to monitor database performance, comprising: receiving at least one rule for query statement execution from a user through a user interface; gathering information from a remote, monitored database related to the monitored database performance during a predetermined time during operation of the database; collecting statistics corresponding to any queries executed during the predetermined time, the statistics consisting of data gathered from performance of the query; testing at least one rule against the statistics corresponding to each query; if the testing results in a rule violation, identifying the query that caused the rule violation; accessing a list of known rule-violating queries in a local repository to determine if the query causing the rule violation has been previously recorded and to determine if a correction for the query exists; and storing the query causing the rule violation in the repository.