Database load trend monitoring method

Abstract

The present invention discloses a database load trend monitoring method. The method comprises: Step S1: periodically collecting database performance data by configuring a timing task, and establishing a resource baseline; Step S2: filtering the collected database performance data, and monitoring a year-on-year trend and a month-on-month trend for each resource usage; Step S3: pushing the resources that are not in the baseline library to the baseline library correction, dynamically generating the baseline by using the system, and re-storing the baseline back to the baseline library; and Step S4: for the resources with the established baseline, comparing the collected performance data with the baseline, if the performance change does not exceed the specified threshold, collecting a baseline corrector for baseline correction, and otherwise, if the performance change exceeds the specified threshold, issuing a performance warning for the resource usage. According to the method disclosed by the present invention, the warning can be automatically issued for the database performance in advance, the probability of occurrence of failure can be reduced, and requirements of standardization and platform management monitoring for mass machines can be satisfied.

Description

technical field [0001] The invention relates to a method for monitoring computer system resources, in particular to a database load trend monitoring method. Background technique [0002] Information technology has become a crucial productivity in the telecommunications industry, and the quality of business systems directly affects the production of enterprises. At present, the database layer is the most critical link in the traditional enterprise architecture. How to discover database performance problems in advance and provide effective solutions is one of the very important responsibilities of the business support department. [0003] In this case, during the system maintenance process, one or more of the following solutions are generally adopted to more or less cause failures caused by the database layer. See figure 1 , the prior art mainly contains the following three kinds: [0004] 1), using third-party software (BOMC) system [0005] Third-party software (Business...

AI Technical Summary

Problems solved by technology

[0014] 1) Wide variety and poor security

[0015] At present, the BOMC systems of major manufacturers are similar, but there are still many problems in the rigor, timeliness, and accuracy of the monitoring indicators of each manufacturer, and the support for various platforms is not very friendly.

[0016] 2) Additional performance overhead

[0020] The above three technologies all have the same problem due to their implementation mechanism. When a problem occurs, manual intervention is required to analyze and operate. This series of operations requires a lot of time and requires experienced engineers to complete manually. To a certain extent, the time for troubleshooting depends greatly on the engineer's personal ability and familiarity with the environment

Images