Microsoft Technology Licensing, LLC

Gaoxiang Xu

Vivek Ravindranath Narasayya

Sudipto Das

Surajit J Chaudhuri

Manoj A Syamala

Bolin Ding

Andrija Jovanovic

Miodrag Radulovic

Jingjing Wang

Systems, methods, and computer-executable instructions for reorganizing a physical layout of data of a database a database. A workload is selected from previously executed database operations. A total resource consumption of the previously executed database operations and of the workload is determined. The total resource consumption of the workload is more than a predetermined threshold of the total resource consumption of the previously executed database operations. Optimization operations for the database are determined using the workload. A cloned database of the database is created. The optimization operations are executed on the cloned database. A database operation is received for the database. The database operation is executed on the database and the cloned database. The performance of the cloned database is verified as being improved compared to the performance of the database based on the executing of the database operation on the database and the cloned database.

Database tuning and performance verification using cloned database

Provided are methods and systems for generating physical database design tuning recommendations. Given a workload, the system analyzes the workload to identify and recommend a set of rowstore and columnstore indexes optimal for the performance of the workload. The system is designed to estimate the size of the columnstore index (at the granularity of each column) without actually building the index, estimate the improvement in query performance that each columnstore index would result in when built, and automatically derive the workload used for the physical design tuning task by analyzing stored query execution history data. This automatic workload derivation is orthogonal to columnstores and can be used even when columnstore indexes are not being used.

Workload-driven recommendations for Columnstore and Rowstore indexes in relational databases

Growing community of inventors

Redmond, WA, United States of America

Gaoxiang Xu