Application program monitoring system and monitoring method

Abstract

The invention provides an application program detecting system, which comprises a JDBC drive interface, at least one database drive and at least one data, wherein the database via a relative database drive is connected with the JDBC drive interface, to receive and execute the statement of one application program via the JDBC drive interface. The invention further comprises a proxy drive respectively connected with relative databases via the JDBC drive interface and at least one database drive to receive the statement of one application program and record the detection information generated by execute statement. The invention provides a relative application program detecting method. The inventive system and method can detect and manage the execution condition of SQL statement via proxy drive, which can easily realize detection and management on databases and realize the detection and management on SQL statement on database drive layer, without third party detecting tools. The invention has the advantages of database spanning, easy detection and simple management.

Description

technical field [0001] The invention relates to the field of electrical digital data processing, in particular to an application program monitoring system and a monitoring method. Background technique [0002] In the existing application program, it is necessary to monitor and manage the execution of the SQL statement sent to the database, so as to find out the performance bottleneck of the system or collect statistics on the operation. [0003] Most applications do not have the function of monitoring and managing SQL, but check the sent SQL statements through the monitoring program of the database server. [0004] Since the JDBC implementation of the database is mostly provided by the database manufacturer, the application program cannot interfere with the process of creating a database connection and using the database connection to execute a query or update statement, so most applications implement it by adding a monitoring program where monitoring is required . [0005...

AI Technical Summary

Problems solved by technology

[0010] The above process needs to add monitoring programs in multiple places of the application program, which affects the normal process of the application program; it is difficult to maintain the application program, and the monitoring programs are distributed in multiple places of the application program, which is not easy to modify; it is not easy to realize the unified opening or closing of monitoring, Need to add additional code and global configuration items to achieve; cross-database monitoring cannot be realized, and the monitoring program in the application must be recoded when changing the target database; some required information such as connection information cannot be obtained through the standard JDBC interface, thus unable to record

Images