The invention discloses an automatic
database performance analysis and
early warning system. The manual analysis evaluation cost for
database performance is high, the manual analysis
evaluation period is longer, and a
service system is often influenced when a failure is found. According to the automatic
database performance analysis and
early warning system, database performance data are periodically acquired through a database performance data timed acquisition tool, the acquired performance data are automatically analyzed in real time through an automatic database performance analysis tool, an analysis result is compared with a database performance
base line to timely find a hidden performance danger, and an alarm is automatically given through a configurable early warning mechanism, so that manual intervention is timely carried out, and operation of the
service system is prevented from being influenced. A method for automatically analyzing the database performance data is divided into two stages, wherein in the first stage, single-time performance data are analyzed; in the second stage, continuous performance data are comprehensively and relationally analyzed, and future performance conditions are predicted. The
early warning system can provide various methods for early warning through electronic mails,
short message service, instant messages, logs, screen display, voices, indicator lamps and the like.