Methods and apparatus for monitoring execution of a database query program

Patent metadata

Field	Value
Publication number	US-9652503-B2
Application number	US-201514682804-A
Country	US
Kind code	B2
Filing date	Apr 9, 2015
Priority date	Sep 28, 2011
Publication date	May 16, 2017
Grant date	May 16, 2017

Abstract

A method includes, receiving, 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 method further includes determining that a performance condition has been satisfied based on the parameter value, and triggering 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.

First claim

What is claimed is:

1. A non-transitory computer-readable storage medium storing instructions that when executed cause a processor to:
receive, during a first portion of an execution of a main program that includes a plurality of database query programs, a parameter value representing performance of a first database query program from the plurality of database query programs;
execute a first configuration for monitoring the performance of the first database query program during the first portion of the execution of the main program;
determine whether a performance condition has been satisfied by the first database query program during the first portion of the execution of the main program, based, at least in part, on the parameter value;
based on a determination that the performance condition has been satisfied, execute a second configuration for monitoring the performance of the first database query program during a second portion of the execution of the main program; and
execute a third configuration for monitoring a second database query program from the plurality of database query programs during the first portion of the execution of the main program, the third configuration being different from the first and second configurations for monitoring the performance of the first database query program.

2. The non-transitory computer-readable storage medium of claim 1 , wherein the performance condition is satisfied in response to the first database query program being executed a threshold number of times, and wherein the parameter value includes an indicator of the number of times that the first database query program has been executed.

3. The non-transitory computer-readable storage medium of claim 1 , wherein the main program is executed during each of a plurality of execution cycles,
and wherein the instructions when executed cause the processor to:
execute the first configuration for monitoring the first database query program at a beginning of each of the plurality of execution cycles of the main program.

4. The computer-readable storage medium of claim 1 , wherein
the main program is executed during each of a plurality of execution cycles,
and wherein the instructions when executed cause the processor to:
execute a third configuration for monitoring the first database query program at a beginning of each execution cycle of the main program from the plurality of execution cycles subsequent to a first execution cycle from the plurality of execution cycles.

5. The non-transitory computer-readable storage medium of claim 1 , wherein the first configuration for monitoring the first database query program has a sampling rate that is different than a sampling rate of the second configuration for monitoring the first database query program.

6. The non-transitory computer-readable storage medium of claim 1 , wherein the parameter value representing performance of the first database query program is based on a duration of execution of the database query program.

7. The non-transitory computer-readable storage medium of claim 1 , wherein the parameter value representing performance of the first database query program is based on at least one of an occurrence of a deadlock or a timeout.

8. The non-transitory computer-readable storage medium of claim 1 , wherein the first database query program is a structured query language (SQL) program.

9. The non-transitory computer-readable storage medium of claim 1 , wherein the parameter value representing performance of the first database query program includes a value based on at least one of a number of timeouts, a number of deadlocks, a duration of an execution, an execution counter value, an input/output (I/O) time, a central processing unit (CPU) time, a CPU usage, a number of get page requests and a wait time of the database query program.

10. A computer-implemented method comprising:
receiving, during a first portion of an execution of a main program that includes a plurality of database query programs, a parameter value representing performance of a first database query program from the plurality of database query programs;
executing a first configuration for monitoring the performance of the first database query program during the first portion of the execution of the main program;
determining whether a performance condition has been satisfied by the first database query program during the first portion of the execution of the main program, based, at least in part, on the parameter value;
based on a determination that the performance condition has been satisfied, executing a second configuration for monitoring the performance of the first database query program during a second portion of the execution of the main program; and
executing a third configuration for monitoring a second database query program from the plurality of database query programs during the first portion of the execution of the main program, the third configuration being different from the first and second configurations for monitoring the performance of the first database query program.

11. The computer-implemented method of claim 10 , wherein the performance condition is satisfied in response to the first database query program being executed a threshold number of times, and wherein the parameter value includes an indicator of the number of times that the first database query program has been executed.

12. The computer-implemented method of claim 10 , wherein the main program is executed during each of a plurality of execution cycles, the method further comprising:
executing the first configuration for monitoring the first database query program at a beginning of each of the plurality of execution cycles of the main program.

13. The computer-implemented method of claim 10 , wherein the main program is executed during each of a plurality of execution cycles, the method further comprising:
executing a third configuration for monitoring the first database query program at a beginning of each execution cycle of the main program from the plurality of execution cycles subsequent to a first execution cycle from the plurality of execution cycles.

14. The computer-implemented method of claim 10 , wherein the first configuration for monitoring the first database query program has a sampling rate that is different than a sampling rate of the second configuration for monitoring the first database query program.

15. The computer-implemented method of claim 10 , wherein the parameter value representing performance of the first database query program is based on a duration of execution of the database query program.

16. The computer-implemented method of claim 10 , wherein the parameter value representing performance of the first database query program is based on at least one of an occurrence of a deadlock or a timeout.

17. The computer-implemented method of claim 10 , wherein the first database query program is a structured query language (SQL) program.

18. The computer-implemented method of claim 10 , wherein the parameter value representing performance of the first database query program includes a value based on at least one of a number of timeouts, a number of deadlocks, a duration of an execution, an execution counter value, an input/output (I/O) time, a central processing unit (CPU) time, a CPU usage, a number of get page requests and a wait time of the database query program.

19. A non-transitory computer-readable storage medium storing instructions that when executed cause a processor to:
receive, during a first por

Assignees

• Bmc Software Inc

Inventors

• Behne Michael D

Classifications

• G06F17/30371

  Physics · mapped topic

• G06F17/30463

  Physics · mapped topic

• G06F17/3051 Primary

  Physics · mapped topic

• G06F16/2365

  Ensuring data consistency and integrity · CPC title

• G06F16/24565 Primary

  Triggers; Constraints · CPC title