Automatic database performance analysis and early warning system

An automatic analysis and database technology, applied in the field of database systems, can solve problems such as long cycle, interruption, heavy workload, etc.

Inactive Publication Date: 2014-10-15
袁晓东
View PDF3 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Although various mainstream database systems provide database performance collection methods and tools, there are also some third-party tools that can be used, but manual analysis and evaluation of database performance requires a lot of work, high cost and long cycle; The first problem is that even if a performance failure is found and dealt with immediately, it has more or less affected or even interrupted the business system

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
  • Automatic database performance analysis and early warning system
  • Automatic database performance analysis and early warning system
  • Automatic database performance analysis and early warning system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0015] The specific implementation of this system is as follows:

[0016] 1. Select a performance data collection tool according to the database type or develop a performance data collection tool by yourself.

[0017] 2. Use the tools in step 1 to collect database performance data.

[0018] 3. According to the performance data format in step 2, define the performance index for the primary analysis of single data and the performance index for secondary analysis of multiple data.

[0019] 4. Develop an automatic analysis tool, which automatically analyzes the performance data in step 2 in two stages to obtain various performance indicators in step 3.

[0020] 5. Develop a database early warning mechanism that includes multiple alarm methods.

[0021] 6. According to the performance indicators in step 3, set the required performance alarm indicators, alarm parameters and alarm methods in the early warning mechanism in step 5.

[0022] 7. Set the interval to regularly run the t...

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

Description

technical field [0001] The technical field of the invention is computer database systems. Background technique [0002] For the vast number of application systems that use databases for data storage and processing, the performance of the database is very critical. If there is a problem with the performance of the database, the business system will not be able to run normally or even be interrupted. The performance status of the database is also changing dynamically, with the increase of data volume, the expansion of business systems, the changes of equipment, network and other software and hardware environments, so it is necessary to continuously monitor the performance status of the database. Deal with it in a timely manner. Although various mainstream database systems provide database performance collection methods and tools, there are also some third-party tools that can be used, but manual analysis and evaluation of database performance requires a lot of work, high cost...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F21/552G06F21/6218
Inventor 袁晓东
Owner 袁晓东
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