Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data-base performance monitoring method

A database and performance technology, applied in hardware monitoring, electrical digital data processing, special data processing applications, etc., can solve problems such as database downtime, database monitoring can only be qualitative but not quantitative, and database performance deterioration cannot be detected in time

Inactive Publication Date: 2008-04-09
CHINA MOBILE GROUP ZHEJIANG
View PDF0 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] For a long time, the monitoring of the core database can only detect the complete downtime of the database, but it is impossible to detect the deterioration of the database performance in time
In the industry, there is no mature database performance monitoring solution, and the monitoring of the database can only be qualitative but not quantitative
At present, the difficulty of database monitoring is that there are hundreds of performance indicators inside the database, and a single indicator can be collected, but the deterioration of a single indicator cannot explain the problem, and there is a need for a comprehensive indicator that can reflect the overall performance of the entire database

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
  • Data-base performance monitoring method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] A preferred embodiment of the present invention and its application effects will now be described in detail in conjunction with the accompanying drawings.

[0020] Referring to Figure 1, for the current Oracle database of Zhejiang Mobile, the database performance monitoring method is used to monitor the comprehensive performance of the database: the existing Pricise monitoring tool will generate an Oracle database performance data every 15 minutes, which includes A lot of Oracle database performance index data are extracted from the above performance index data: CPU waiting time, I / O waiting time and total database waiting time; then according to our comprehensive performance calculation formula T c =(CPU waiting time+I / O waiting time) / database total waiting time*100%, get the current comprehensive performance index value T of this database c ; put T c with a pre-set normal threshold T a compare size, T a The range of value is 40%~60%, preferably 50%, if T c less th...

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 database performance monitoring method, which belongs to the field of database performance monitoring technology. The monitoring method obtains the relevant performance parameters from the database, (CPU waiting time plus I / O waiting time)divided by total waiting time of the database, then multiplied by 100 percent shall be considered as a comprehensive index of the database performance, and the indicator is compared with preset normal index value / performance poor index value, thereby generating an alarm in accordance with the comparison. The monitoring method can promptly and effectively monitor the database performance.

Description

technical field [0001] The invention belongs to the technical field of database performance monitoring, and in particular relates to a database performance monitoring method. Background technique [0002] For a long time, the monitoring of the core database can only detect the complete downtime of the database, but cannot detect the deterioration of database performance in time. In the industry, there is no mature database performance monitoring solution, and the monitoring of the database can only be qualitative but not quantitative. At present, the difficulty of database monitoring is that there are hundreds of performance indicators inside the database, and a single indicator can be collected, but the deterioration of a single indicator cannot explain the problem. A comprehensive indicator is needed to reflect the comprehensive performance of the entire database. Contents of the invention [0003] In order to solve the problems in the prior art, the present invention a...

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/34G06F17/30
Inventor 王晓征
Owner CHINA MOBILE GROUP ZHEJIANG
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com