Database monitoring system
First Claim
1. A database monitoring system that monitors performance of a database system in which database events having an execution code path are occurring, comprising:
- a collection of database system object types each having at least one object attribute that corresponds to a property of the object type a rule engine that evaluates rules for taking action based on database system performance;
wherein a rule is triggered by the occurrence of a database event and specifies a condition and an action to be taken by the monitoring system when the condition is met; and
wherein the rule engine evaluates the condition and takes the specified action if the condition is met as part of the database event'"'"'s execution code path.
2 Assignments
0 Petitions
Accused Products
Abstract
A framework is provided within a database system for specifying database monitoring rules that will be evaluated as part of the execution code path of database events being monitored. The occurrence of a selected database event triggers a rule that evaluates some parameter of an object related to the event against a condition in the rule. If the condition is met, a specified action is taken that can alter the execution of the database event or database system performance. Lightweight aggregation tables are utilized to enable aggregation of object parameter values so that presently occurring events can be compared to a summary of the object parameter values from previously occurring database events. Signatures are assigned to queries based on the structure of the query plan so that information in the lightweight aggregation tables can be grouped according to query signature.
-
Citations
36 Claims
-
1. A database monitoring system that monitors performance of a database system in which database events having an execution code path are occurring, comprising:
-
a collection of database system object types each having at least one object attribute that corresponds to a property of the object type a rule engine that evaluates rules for taking action based on database system performance;
wherein a rule is triggered by the occurrence of a database event and specifies a condition and an action to be taken by the monitoring system when the condition is met; and
wherein the rule engine evaluates the condition and takes the specified action if the condition is met as part of the database event'"'"'s execution code path. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A method that initiates a response action when a database event meets a specified condition, comprising:
-
inserting a branch instruction within the execution code path of the database event that branches to a set of rules, wherein a rule specifies the condition and the response action to be taken when the condition is true;
triggering the specified action when the database event meets the specified condition. - View Dependent Claims (12, 13, 14, 15, 16, 17)
-
-
18. One or more computer readable media comprising computer executable instructions for monitoring performance of a database system in which database events having an execution code path are occurring, the instructions comprising:
-
defining a collection of database system object types each having at least one object attribute that corresponds to a property of the object type as part of the database event'"'"'s execution code path, evaluating rules for taking action based on database system performance;
wherein a rule is triggered by the occurrence of a database event and specifies a condition on at least one object attribute and an action to be taken by the monitoring system when the condition is met; and
taking the specified action if the condition is met. - View Dependent Claims (19, 20, 21, 22, 23, 24, 25, 26, 27)
-
-
28. A database monitoring system schema comprising:
-
a first element representing a monitored object type; and
a set of attribute elements and events mapped to each monitored object type representing properties of an instance of the monitored object type. - View Dependent Claims (29, 30)
-
-
31. A apparatus that initiates a response action when a database event meets a specified condition, comprising:
-
means for inserting a database monitoring rule within the execution code path of the database event that specifies the condition and the response action to be taken when the specified condition is true; and
means for triggering the specified response action when the database event meets the specified condition. - View Dependent Claims (32, 33, 34, 35, 36)
-
Specification