Enable automatic tuning for Microsoft Azure SQL servers in order to monitor database queries and improve database workload performance. Automatic Tuning is a built-in intelligence feature that automatically tunes your Azure SQL databases to optimize their performance. The feature options are:
FORCE PLAN – this option identifies SQL queries that are using an execution plan that is slower than the previous optimal plan, and queries that are using the last known optimal plan instead of the regressed plan.
CREATE INDEX – this recommendation identifies database indexes that may improve performance of your workload, creates indexes, and automatically verifies if the performance of SQL queries has been improved.
DROP INDEX – this option identifies redundant and duplicate indexes daily, except for unique indexes, and indexes that were not used for a long time, such as more than 90 days. Note that this option is not compatible with applications using partition switching and index hints. Dropping unused indexes is not currently supported for Premium and Business Critical service tiers.
This rule resolution is part of the Cloud Conformity Security & Compliance tool for Azure
Automatic Tuning feature learns horizontally from all the SQL databases provisioned within the Azure cloud through AI and Machine Learning (ML), and it dynamically improves its tuning actions. The longer an Azure SQL database server runs with automatic tuning on, the better it performs.
To determine if automatic tuning is enabled for your Azure SQL database servers, perform the following actions:Note: Getting Automatic Tuning feature configuration status using Microsoft Azure CLI or Azure PowerShell is not currently supported.
Remediation / Resolution
o enable and configure automatic tuning for your Microsoft Azure SQL database servers, perform the following actions:Note: Enabling and configuring Automatic Tuning for SQL database servers using Microsoft Azure CLI or Azure PowerShell is not currently supported, the feature can be configured only through Azure Management Console (Azure Portal).
Unlock the Remediation Steps
Gain free unlimited access
to our full Knowledge Base
Over 750 rules & best practices
You are auditing:
Enable Automatic Tuning for SQL Database Servers
Risk level: Medium