Database performance evaluation management method and device

Abstract

The embodiment of the invention discloses a database performance evaluation management method and device. The method comprises: acquiring multiple key performance indexes used for evaluating the performance of a to-be-evaluated database; inputting the plurality of key performance indexes into a preset performance evaluation model, and outputting a performance evaluation result of the to-be-evaluated database, wherein the preset performance evaluation model comprises a performance evaluation formula and a reference factor; and analyzing and optimizing the to-be-evaluated database according to the performance evaluation result. Compared with the prior art, the method has the following advantages: (1) compared with artificial experience judgment, the method is more scientific and efficient; and (2) a comprehensive management system of the performance problem is realized, and compared with the fact that a database system administrator processes the performance problem in a plugging (eventtriggering) mode, the capabilities of analyzing the performance problem and solving the performance problem improved, the initiative of performance management is recovered, and positive prevention andautomatic processing can be realized.

Description

technical field [0001] The embodiments of the present invention relate to the field of computer technology, and in particular to a database performance evaluation management method and device. Background technique [0002] At present, database performance evaluation and management is mainly through professional database system administrators to make subjective evaluations of database performance according to the response time of the database, the number of concurrent databases, etc. After evaluating the performance of the database, managing and optimizing the performance of the database is also a cumbersome and complicated task, especially when the number of databases reaches a certain scale, the workload of the database administrator will increase dramatically. At present, the following problems exist in the performance management of the database: [0003] (1) The types of coverage databases are not comprehensive. At present, there are many types of mainstream databases, ...

AI Technical Summary

Problems solved by technology

At present, there are many types of mainstream databases, including traditional commercial database products Oracle, Db2, and SQL Server, open source relational databases MySQL, PostgreSQL, etc., and various other NoSQL products such as MongoDB, Redis, etc., only for one or one type of database performance evaluation and management, it is difficult to meet the demand

It is required to be very proficient in mainstream databases, and it is also a relatively big challenge for professional database system administrators.

[0004] (2) There is no distinction between different business types, and the degree of refinement of database performance evaluation and management is not high

[0005] (3) Database performance evaluation lacks quantification

The performance of the database lacks in-depth analysis of quantification and correlation. For large-scale databases, it is impossible to quickly form a comprehensive and accurate database system performance report

[0006] (4) Database performance management is not systematic, making it difficult to prevent problems

Images