Monitoring stored procedure execution

摘要

A computer-implemented method, system, and/or computer program product monitors stored procedures that are executed in a database management system. A determination is made, for a stored procedure that is executed in a database management system, of an identification of the stored procedure and event data related to the stored procedure. The event data includes when the stored procedure began and ended executing, an SQL identifier for an SQL statement in the stored procedure, and a counter of how many times the SQL statement executed. The database management system provides values of parameters used when executing the SQL statement. These values are then correlated with the count of how many times the SQL statement executed.

主权项

1. A computer-implemented method of monitoring stored procedures executed in a database management system, the computer-implemented method comprising:
a computer determining, for a stored procedure that is executed in a database management system, an identification of the stored procedure and event data related to the stored procedure, wherein the event data related to the stored procedure comprises: a first time indicative of a beginning of an execution of the stored procedure, a second time indicative of an end of the execution of the stored procedure, a structured query language (SQL) statement identifier assigned to an SQL statement that is executed as part of the stored procedure, and a counter for said SQL statement identifier, wherein said counter indicates how many times said SQL statement executed between the first time and the second time; providing, by the database management system, regular database monitoring information, wherein the regular database monitoring information comprises values of parameters of the executed SQL statement that is identified by the SQL statement identifier; calculating an average parameter value of at least one parameter of the executed SQL statement; and correlating said values of parameters of the executed SQL statement identified by the SQL statement identifier with the counter of the number of executions the SQL statement executed between the first time and the second time as part of the stored procedure, wherein said correlating monitors the stored procedure executed in the database management system, and wherein said correlating is further performed by multiplying the average parameter value of said at least one parameter with the number of executions of the identified SQL statement, wherein the SQL statement identifier, representing the SQL statement having the average parameter value, equals the SQL statement identifier relating to the number of executions.