Apparatus, method and computer-code for detecting changes in database-statement execution paths
AssigneePrecise Software Solutions, Inc.
InventorsEhud Eshet, Sigal Gelbart, Dan Zada, Liad Hacmon
Life of this patent
Estimating the term…
Abstract
Apparatus, methods, and computer code for monitoring a database and for detecting execution plan changes in the database. In the event that an execution plan is detected for a given database statement during the course of the monitoring, an alert signal may be generated. Optionally, the generation of the alert signal is further contingent upon a property of the database statement for which an execution plan change has been detected, for example, an execution time. In some embodiments, a detection agent is configured to repetitively attempt to detect an execution plan, for example, in accordance with a specified frequency parameter.
Claims21
An apparatus for monitoring execution plans of a relational database, the apparatus comprising:
- a) at least one of a volatile and a non-volatile memory;
- configured to store a detector agent and an alert agent;
- and
- b) a microprocessor operative to:
- i) execute code of the detector agent to monitor the performance of the relational database to detect an execution plan change for at least one database statement handled by the relational database;
- and
- ii) execute code of the alert agent to generate an alert signal, contingent on results of said detecting of said execution plan change.
A method for monitoring execution plans of a relational database, the method comprising:
- a) automatically and electronically monitoring the performance of the relational database by executing code of a detector agent by a microprocessor to detect an execution plan change for at least one database statement handled by the relational database;
- and
- generating an alert signal, contingent on results of said detecting of said execution plan change.
Dependencies are inferred from the claim text.