摘要:
An apparatus, system, and method are disclosed for evaluating database accesses. The apparatus may comprise a computer program that causes a computer system to exchange profiling data between a client application module and a database module; execute a database access; determine a database access policy violation at a detection point module; and selectively request context information from a context point module related to the database access.
摘要:
An apparatus, system, and method are provided for evaluating database accesses. The apparatus may comprise a computer program that causes a computer system to exchange profiling data between a client application module and a database module; execute a database access; determine a database access policy violation at a detection point module; and selectively request context information from a context point module related to the database access.
摘要:
Embodiments of the invention provide techniques for troubleshooting of computer systems using a fault tree analysis. In one embodiment, data parameters describing a status of a system may be monitored to determine the existence of a fault. In the event of a fault, fault tree analysis metadata may be evaluated to attempt to determine a root cause of the fault. If a root cause can be automatically determined, it may be presented to a user in a troubleshooting console, or may be used to trigger an automated corrective action. Alternatively, if a root cause cannot be automatically determined, the user may be presented with additional fault tree analysis metadata and any relevant data parameters in the troubleshooting console, so that the user may determine the root cause of the fault event.
摘要:
Embodiments of the invention provide techniques for troubleshooting of computer systems using a fault tree analysis. In one embodiment, data parameters describing a status of a system may be monitored to determine the existence of a fault. In the event of a fault, fault tree analysis metadata may be evaluated to attempt to determine a root cause of the fault. If a root cause can be automatically determined, it may be presented to a user in a troubleshooting console, or may be used to trigger an automated corrective action. Alternatively, if a root cause cannot be automatically determined, the user may be presented with additional fault tree analysis metadata and any relevant data parameters in the troubleshooting console, so that the user may determine the root cause of the fault event.
摘要:
Providing information of a monitored system through a graphical user interface (GUI) of a monitoring application to support simplified or automatic identification of events. The method includes initiating an event pattern script recording. The method also includes keeping track of user actions on said GUI and on activated GUI panels during said event pattern script recording by requesting a user to specify, once the user activates a further GUI panel, which panel information in a current GUI panel triggered activation of said further GUI panel and based on what criterion the triggering occurred. The user specified information results in triggering information. The method also includes, in response to receiving an indication that an event has been identified, stopping said event pattern script recording. The method also includes, storing said event pattern script recording, GUI panel information and said triggering information.
摘要:
A method, system, and computer program product for providing information of a monitored system through a graphical user interface (GUI) of a monitoring application to support simplified or automatic identification of events. The method includes, among other possible operations, initiating an event pattern script recording. The method also includes keeping track of user actions on said GUI and on activated GUI panels during said event pattern script recording by requesting a user to specify, once the user activates a further GUI panel, which panel information in a current GUI panel triggered activation of said further GUI panel and based on what criterion the triggering occurred. The user specified information results in triggering information. The method also includes, in response to receiving an indication that an event has been identified, stopping said event pattern script recording. The method also includes, storing said event pattern script recording containing identification information identifying the event, GUI panel information about said activated GUI panels during said event pattern script recording and said triggering information.
摘要:
A method for tuning a database system is disclosed. A tuning strategy is received comprising a first procedure to determine a suggested tuning action, and a second procedure to measure performance of the database system. The suggested tuning action is determined and pre-action performance measured according to the respective procedures. Undo information that indicates how to undo the database system state change of the suggested tuning action is recorded in a database system state history. After executing the suggested tuning action, post-action database system performance is measured according to the second procedure. When the post-action performance is lower than the pre-action performance, the database system state change is undone using the undo information. Embodiments enabling to create new tuning strategies, downloading existing tuning strategies, sharing own tuning strategies and changing existing tuning strategies are disclosed as well.
摘要:
A method for tuning a database system is disclosed. A tuning strategy is received comprising a first procedure to determine a suggested tuning action, and a second procedure to measure performance of the database system. The suggested tuning action is determined and pre-action performance measured according to the respective procedures. Undo information that indicates how to undo the database system state change of the suggested tuning action is recorded in a database system state history. After executing the suggested tuning action, post-action database system performance is measured according to the second procedure. When the post-action performance is lower than the pre-action performance, the database system state change is undone using the undo information. Embodiments enabling to create new tuning strategies, downloading existing tuning strategies, sharing own tuning strategies and changing existing tuning strategies are disclosed as well.
摘要:
A method, system, and computer program product are provided for operating a relational database management system (RDBMS). In order to operate a RDBMS, information is read from a first execution plan in response to an execution request for a second individual database statement of a second sequence of database statements. The information is processed and pool resource requirements for execution of further individual database statements of the second sequence of database statements are evaluated. A preparation request is sent for pool modification based on the evaluated pool resource requirements to an asynchronous pool preparation queue. Then the second individual database statement of the second sequence of database statements is executed. The information indicative of the progression of execution of the second individual database statement is stored in a position register.
摘要:
Techniques are provided for tuning work. In response to identifying a trigger for a work, automatic tuning is invoked. The trigger indicates that a performance goal for the work has been missed. The work is analyzed. A tuning operation is selected for the work based on a tuning history. The selected tuning operation is implemented for the work.