US 9,015,188 B2Granted

Methods and apparatus for monitoring execution of a database query program

AssigneeBMC Software, Inc.

InventorMichael D. Behne

Life of this patent

Estimating the term…

Loading patent…

Abstract

In one general aspect, a computer-readable storage medium can be configured to store instructions that when executed cause a processor to perform a process. The instructions can include instructions to receive, during a first portion of an execution of a main program including a database query program and based on a first configuration for monitoring the database query program, a parameter value representing performance of execution of the database query program. The instructions can include instructions to produce an indicator that a performance condition has been satisfied based, at least in part, on the parameter value, and instructions to trigger execution of a second configuration for monitoring the database query program during a second portion of the execution of the main program in response to the performance condition being satisfied.

Claims20

Dependent claims

An apparatus, comprising:

at least one processor;
and
at least one memory device comprising instructions stored thereon that, when executed by the at least one processor, are configured to cause the apparatus to implement:
a monitoring module configured to receive an indicator of initiation of an execution cycle of a main program including a database query program configured to execute a plurality of times during the execution cycle of the main program;
and
a monitoring configuration manager configured to, in response to the received indicator, trigger performance monitoring, by the processor, of multiple executions of the database query program during the execution cycle of the main program,
the performance monitoring of the multiple executions of the database query program during the execution cycle of the main program including monitoring a first execution of the database query program based on a first monitoring configuration and monitoring a second execution of the database query program based on a second monitoring configuration, the first monitoring configuration being different than the second monitoring configuration,
the monitoring configuration manager being configured to terminate the performance monitoring of the multiple executions of the database query program during the execution cycle of the main program based on at least one parameter value related to the database query program satisfying a performance condition.

5 more elements

A non-transitory computer-readable storage medium storing instructions that when executed cause a processor to:

establish, at a beginning of each of a plurality of execution cycles of a main program including a database query program, a configuration for monitoring executions of the database query program within the execution cycle of the main program,
monitor a first execution of the database query program within the execution cycle of the main program based on the established configuration for monitoring executions of the database query program;
modify, during the execution cycle of the main program, the configuration for monitoring executions of the database query program;
and
monitor a second execution of the database query program within the execution cycle of the main program based on the modified configuration for monitoring the database query program.

2 more elements

Dependencies are inferred from the claim text.