Business process visualization based SQL performance monitoring method

Abstract

The invention discloses a business process visualization based SQL performance monitoring method. The method comprises the following steps of a) dividing a business process into a plurality of business nodes according to a data flow direction and performing visualized graph display; b) configuring an SQL statement associated with the business node and a data table required to be accessed at each business node to realize transparent association of the business process and an underlying SQL of a database; c) regularly collecting the SQL statement which influences the business performance for the database and extracting a related data table name executed in the SQL statement; and d) searching for the business node associated with the extracted related data table name to realize business fault positioning. According to the method, the transparent association of the business process and the underlying SQL of the database is realized and the business process is subjected to visualized graphic display, so that effective business problem early warning is provided, the fault positioning precision is improved, and the operation and maintenance costs are greatly reduced.

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