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.

Abstract: A system and method for monitoring database performance. In one embodiment, a method may comprise detecting a change to a database. In response to detecting the change, the method may predict a set of outcomes resulting from the change, monitor the database to determine whether any outcome of the set of outcomes has occurred, and report that one or more of the predicted outcomes has occurred. In one embodiment, the set of outcomes may be predicted based on a set of predictive rules. Determining whether any outcome of the set of outcomes has occurred may comprise comparing the performance of the database after the change to a historical baseline. Furthermore, reporting on the set of outcomes may include making recommendations on alternate changes to the database and summarizing the historical baseline. In one embodiment the set of predictive rules may be derived from multiple databases on the recorded effects of various changes.

Abstract: A system, method and computer program product for analyzing file I/O activity on local attached storage devices within a computer network is provided. In an embodiment, a software agent executes on one or more servers within the network, and monitors the I/O activity on the network's local attached storage (e.g., SAN, NAS, and IDE and SCSI disks). A management interface is also provided for monitoring I/O activity-related data and for receiving reports on such I/O activity. In an embodiment, collected I/O-related data and any predefined I/O metrics are stored in a central repository (e.g., a relational database). The system, method and computer program product provide accurate metrics to assists system administrators in deciding, justifying and validating resource purchases for and allocations within the network.

Abstract: Methods and systems are provided for performance management methodology and exception report workflows in a performance management system. A performance management methodology workflow may assist a user in performing a plurality of performance management tasks in a performance management system: detecting a performance problem in a computer system, identifying a root cause of the performance problem in a particular application tier or particular system component, improving the performance of the computer system by implementing a solution to the root cause, and verifying that the solution to the root cause has improved the performance problem. An exception report workflow may include defining a plurality of exceptions for a managed computer system comprising a plurality of application tiers. One or more of the plurality of exceptions is triggered in response to collected performance metrics.

Abstract: A method for monitoring a computer system, the method comprising the steps of analyzing access requests, thereby determining its respective waiting time period, detecting from the waiting time periods selected waiting time periods which exceed a predetermined threshold value, retrieving information relating to waiting access requests which are associated with selected waiting time periods, retrieving information relating to at least one storage unit, which is associated with waiting access requests; and retrieving information relating to at least one storage device, containing at least one storage unit.