Tuning an Azure SQL Database
Automatic Tuning
Azure SQL Database Automatic tuning utilizes artificial intelligence to continuously monitor and improve queries executed on an Azure SQL Database.
Automatic tuning observes the workload and applies recommendations to speed up performance. The recommendations are applied when the database activity is low so that there aren't any performance impacts when applying recommendations.
The following are the options which are available for automatic tuning.
Create Index
Automatically identify and implement missing indexes to improve workload performance. It also verifies whether or not the indexes created have any improvement on the performance.
Drop Indexes
Automatically identifies and removes duplicate, redundant, ...
Get Professional Azure SQL Database Administration now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
