Hardware health assessment method of database server based on expert model

A health assessment and database technology, applied in hardware monitoring, electrical digital data processing, instruments, etc., can solve problems such as manual analysis, simple rules, and inability to cope with dynamic thresholds, so as to avoid economic losses and solve high cost effects

Inactive Publication Date: 2019-03-29
INFORMATION & COMM BRANCH OF STATE GRID JIANGSU ELECTRIC POWER +2
View PDF4 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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...

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Hardware health assessment method of database server based on expert model
  • Hardware health assessment method of database server based on expert model

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] The preferred implementation of the device and method of the present invention will be further described in detail below in conjunction with the accompanying drawings.

[0032] 1. Overall plan

[0033] The invention proposes a database server hardware health assessment method based on an expert model. The assessment method includes collecting operating system hardware indicators, including selecting indicators from CPU, memory, I / O, file system, and network, and dividing the hardware indicators into experts. In-model indicators and auxiliary analysis indicators;

[0034] Formulate expert model rules: assign score weights to the indicators in the expert module, and formulate multi-level thresholds and deduction standards, and the scores of the corresponding grades will be deducted when the indicator value falls within different threshold ranges;

[0035] Apply the expert model to the database server hardware object, and the operating system will automatically collect ha...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F11/34
CPCG06F11/3447G06F11/3476G06F2201/80
Inventor 夏飞钱琳俞俊朱广新强润皓
Owner INFORMATION & COMM BRANCH OF STATE GRID JIANGSU ELECTRIC POWER
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap