Patent ID: 8887009

Claim:
A system for managing performance of database transactions, the system comprising: at least one database configured to store data; at least one application configured to interact with the data of the at least one database through a plurality of database transactions; and a management subsystem configured to generate one or more alerts identifying degrading ones of the plurality of database transactions, the management subsystem configured to execute on one or more computing devices and comprising, a monitor module comprising one or more computer hardware processors, the monitor module configured to track one or more performance measurements of the plurality of database transactions, a modeler module comprising one or more computer hardware processors, the modeler module configured to correlate the one or more tracked performance measurements beginning at a first data point of a particular database transaction with one or more independent variables and to assign at least a first performance model to represent the one or more tracked performance measurements to generate a first trend of predicted performance measurements of the particular database transaction, a trend change module comprising one or more computer hardware processors, the trend change module configured to automatically detect within the one or more tracked performance measurements at least one substantial trend change in the first trend of the one or more tracked performance measurements, wherein the trend change module automatically detects a trend change by iteratively selecting a second data point for the modeler module to generate at least a second performance model for a second trend of predicted performance measurements beginning at the second data point, wherein detection of the trend change by the trend change module includes at least determining that at least three measured data points prior to the second data point fall outside of the second trend, an interface module comprising one or more computer hardware processors, the interface module configured to trigger an alert when the second trend of the second performance model indicates that the predicted performance measurements of the particular database transaction are degrading at or above a threshold rate to identify whether the particular database transaction needs to be tuned; and wherein the second performance model indicates whether I/O channels associated with the execution of the plurality of database transactions will near capacity in the future.