Abstract: Systems and techniques for determining a total predicted index fragmentation associated with executing a structured query language statement are described. An execution plan associated with the structured query language statement may be determined. A plurality of tables estimated to be affected by execution of the structured query language statement may be determined. For individual tables, an estimated number of rows that the structured query language statement is to affect may be determined. A predictive model, such as a support vector machine, may be used to determine, for individual tables whose indexes are estimated to be affected, a predicted change in an average index fragmentation percentage associated with individual indexes on the affected tables. The sum of the predicted change in the average index fragmentation percentage of affected indexes may be determined to determine the total predicted index fragmentation associated with executing the structured query language statement.

Abstract: In one embodiment, a method includes selecting a plurality of indexes of a database table, receiving an indication of a set of index pairs in the plurality of indexes that are deemed to at least partially overlap, and determining a degree of overlap between the indexes of each index pair. The method further includes determining a suggested merge relationship between the indexes of each of the index pairs. The method also includes generating an index model comprising interconnected index objects. The interconnected index objects represent the indexes of the index pairs. Interconnections between the interconnected index objects reflect the suggested merge relationship between the indexes of each index pair. Moreover, the method includes outputting a graphical representation of the index model. Additionally, the method includes allowing a user to graphically select index pairs to merge in a system-determined order.

Abstract: Systems and techniques for determining a total predicted index fragmentation associated with executing a structured query language statement are described. An execution plan associated with the structured query language statement may be determined. A plurality of tables estimated to be affected by execution of the structured query language statement may be determined. For individual tables, an estimated number of rows that the structured query language statement is to affect may be determined. A predictive model, such as a support vector machine, may be used to determine, for individual tables whose indexes are estimated to be affected, a predicted change in an average index fragmentation percentage associated with individual indexes on the affected tables. The sum of the predicted change in the average index fragmentation percentage of affected indexes may be determined to determine the total predicted index fragmentation associated with executing the structured query language statement.

Abstract: Systems and methods are disclosed for monitoring and managing data transactions, such as SQL transactions. In certain examples, a management subsystem generates an alert identifying degrading database transactions to facilitate preventative tuning or other maintenance. In particular, a monitor module tracks performance measurements (e.g., logical reads) of select transactions. A modeler correlates the performance measurements and assigns first performance model(s) to represent the performance measurements and predicted performance measurements of a particular transaction. A trend change module detects a significant change in a trend and/or variance of the performance measurements and can cause the modeler module to generate a second performance model to represent at least a portion of the performance measurements and the predicted performance measurements of the particular transaction.

Abstract: Systems and methods are disclosed for monitoring and managing data transactions, such as SQL transactions. In certain examples, a management subsystem generates an alert identifying degrading database transactions to facilitate preventative tuning or other maintenance. In particular, a monitor module tracks performance measurements (e.g., logical reads) of select transactions. A modeler correlates the performance measurements and assigns first performance model(s) to represent the performance measurements and predicted performance measurements of a particular transaction. A trend change module detects a significant change in a trend and/or variance of the performance measurements and can cause the modeler module to generate a second performance model to represent at least a portion of the performance measurements and the predicted performance measurements of the particular transaction.

Abstract: Systems and methods are disclosed for monitoring and managing data transactions, such as SQL transactions. In certain examples, a management subsystem generates an alert identifying degrading database transactions to facilitate preventative tuning or other maintenance. In particular, a monitor module tracks performance measurements (e.g., logical reads) of select transactions. A modeler correlates the performance measurements and assigns first performance model(s) to represent the performance measurements and predicted performance measurements of a particular transaction. A trend change module detects a significant change in a trend and/or variance of the performance measurements and can cause the modeler module to generate a second performance model to represent at least a portion of the performance measurements and the predicted performance measurements of the particular transaction.