摘要 |
A method to monitor database performance includes gathering information from a remote, monitored database related to the monitored database performance during a predetermined time, collecting statistics corresponding to any queries executed during the predetermined time, testing at least one rule against the statistics corresponding to each query, and if the testing results in a rule violation, identifying the query that caused the rule violation. A method to monitor database performance includes gathering statistics related to execution of a query statement, comparing at least one of the statistics against at least one rule to determine if the statistics violates a threshold established by the rule, if the statistic violates the threshold, identifying the query statement as a violating query statement, and repeating the comparing and identifying until all rules have been compared. A system has a local repository and a rules engine to gather information from at least one remote, monitored database, locate query statement executions in the information and to collect statistics with regard to the query execution, and test at least one rule against the statistics to determine if the query statement violates the rule. |