Business process visualization based SQL performance monitoring method

Abstract

The invention discloses a SQL performance monitoring method based on business process visualization, which includes the following steps: a) dividing the business process into multiple business nodes according to the data flow direction, and performing visual graphic display; b) configuring and The SQL statements associated with the business node and the data tables that need to be accessed realize the transparent association between the business process and the underlying SQL of the database; c) regularly collect SQL statements that affect business performance from the database, and extract relevant data tables executed in the SQL statements name; d) Find the service node associated with the extracted name of the related data table to realize the location of the service failure. The invention realizes the transparent association between the business process and the underlying SQL of the database, and displays the business process in a visualized graph, thereby providing an effective early warning of business problems, increasing the accuracy of fault location, and greatly reducing the operation and maintenance cost.

Description

technical field [0001] The invention relates to a SQL performance monitoring method, in particular to a SQL performance monitoring method based on business process visualization. Background technique [0002] With the rapid development of the business of each company, the number of supported users continues to grow, and the amount of business data continues to rise. At the same time, in order to meet the needs of business development, the application version changes frequently, and more and more new systems are built. This will undoubtedly have a great impact on the performance and stability of the business system. At the same time, the system structure of the business support system is becoming more and more complex, the system complexity is getting higher and higher, and the management is becoming more and more difficult. Now basically no one can Figure out the data structure and data flow of the entire system. As a result, the black box problem of IT system application a...

AI Technical Summary

Problems solved by technology

If you do not understand the program business and database structure, it will cause inaccurate business fault location, uncontrollable business and SQL changes, and requires expert-level business personnel to operate, which is difficult to sort out, very costly, and extremely low maintenance efficiency

The main disadvantages of the existing technology are as follows: 1. The business process in the system is not clear; 2. It is impossible to determine which SQLs have been executed by the business; 3. The business fault location is not accurate; 4. There is a problem with the SQL performance, and it is impossible to judge which businesses are affected; 5. Unable to control the impact of business and SQL changes

Images