A database session tracking and analysis method and device thereof

Abstract

The invention discloses a database session tracking and analysis method, which includes obtaining the identity code of the fault session and the serial interface code; calling a preset first function, the first function tracks the fault session in real time according to the identity code, and passes the Encoding returns the captured session information in real time; calls the preset second function, and the second function analyzes and filters the session information returned by the first function, obtains useful information and stores it in the preset information library; among them, after the fault session ends, the second The first function stops running; the second function stops running after the second function finishes analyzing and filtering all session information received by itself and the first function stops running. The invention can automatically track, analyze and screen fault sessions, has high work efficiency and accuracy, and has good coherence; the invention also discloses a device, equipment and computer-readable storage medium based on the above method.

Description

technical field [0001] The invention relates to the technical field of database monitoring, in particular to a database session tracking and analysis method. The invention also relates to a database session tracking and analysis device, equipment and computer-readable storage medium. Background technique [0002] A database session refers to a process generated in the database after a user establishes a connection with the database through a user process. The performance analysis and tuning of a database session has always been a hot topic. [0003] All current relational databases can only track sessions, but there is no established method or device to automatically analyze database sessions. Generally, after the tracking is completed, the tracked information is manually analyzed, screened, and manually analyzed. , the efficiency of performance analysis is relatively low, and human misjudgment may occur, the accuracy is low, and the consistency of session tracking and anal...

AI Technical Summary

Problems solved by technology

[0003] All current relational databases can only track sessions, but there is no established method or device to automatically analyze database sessions. Generally, after the tracking is completed, the tracked information is manually analyzed, screened, and manually analyzed. , the efficiency of performance analysis is relatively low, and human misjudgment may occur, the accuracy is low, and the consistency of session tracking and analysis is poor

Images