Hardware health assessment method of database server based on expert model

Abstract

The invention discloses a hardware health evaluation method of a database server based on an expert model. The evaluation method includes collecting operating system hardware indexes, dividing the hardware indexes into indexes in expert model, assigning score weights to the indexes in expert model, and establishing multi-level thresholds and deduction standards, wherein the index values fall within different threshold ranges and deduct corresponding grade scores; automatically and periodically collecting hardware indicators; according to the rules of expert model, the hardware index of database server is calculated, and the health score of database server hardware is output. The above evaluation method selects the key indexes of database hardware and solves the reliability problem of indexselection. Combining and matching the indexes, a database hardware health model is constructed, and the problem of singularity of evaluation is solved by assigning weights to the indexes in the modeland setting dynamic thresholds. Through automatic collection and model calculation, the hardware health degree of database is evaluated, and the problem of high cost of manual evaluation is solved.

Description

technical field [0001] The invention relates to the field of database operation and maintenance, in particular to a database server hardware health assessment method based on an expert model. Background technique [0002] On the one hand, the problem of database operation comes from the database software itself, and a large part of the reason is from the hardware problem of the database. When analyzing database hardware problems, DBAs usually collect key hardware indicators manually or using tools, evaluate the health of the hardware based on their own experience, and analyze problems based on phenomena and indicators. [0003] Although there are many large-scale database monitoring tools at present, these tools usually only obtain some key indicators of the database hardware on a regular basis. The tools prefabricate the thresholds of these indicators, and generate some threshold alarms when the database indicators deteriorate. Operation and maintenance personnel collect d...

AI Technical Summary

Problems solved by technology

The indicator threshold setting of ordinary operation and maintenance tools is often to generate an alarm when the indicator value exceeds a certain constant. The rules are too simple to deal with complex dynamic thresholds.

[0005] Changes in the health of database hardware are caused by the joint action of multiple indicators. Changes in a single indicator cannot reflect the impact on the database. Ordinary operation and maintenance tools lack the ability to systematically evaluate the health of database hardware and only play a role in index collection. In the end, the role of the device still requires manual analysis by the DBA

Images