Optimizing Performance of Azure SQL Database
Question
You have an Azure SQL database named DB1 that contains multiple tables.
You need to improve the performance of DB1. The solution must minimize administrative effort.
What should you use?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.D
Azure SQL Database and Azure SQL Managed Instance automatic tuning provides peak performance and stable workloads through continuous performance tuning based on AI and machine learning.
Automatic tuning is a fully managed intelligent performance service that uses built-in intelligence to continuously monitor queries executed on a database, and it automatically improves their performance.
https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-overviewTo improve the performance of an Azure SQL database, the solution must be able to identify the database performance bottleneck and provide automated solutions to fix it. The solution must also minimize administrative effort.
Option A: Azure Monitor is a monitoring service that provides a centralized platform to monitor the performance and availability of Azure resources. Although Azure Monitor provides metrics and logs for SQL databases, it does not provide a specific solution for optimizing the performance of SQL databases. Therefore, this option is not suitable for improving the performance of DB1.
Option B: Azure Advisor is a service that provides recommendations to optimize the Azure resources for cost, security, performance, and availability. Although Azure Advisor provides performance recommendations for SQL databases, it does not provide automated solutions for optimizing SQL databases. Therefore, this option is not suitable for improving the performance of DB1.
Option C: Query Performance Insight is a feature that provides insights into the database query performance. Query Performance Insight provides a list of the top queries by their frequency, duration, and resources consumed. However, Query Performance Insight does not provide automated solutions for optimizing SQL databases. Therefore, this option is not suitable for improving the performance of DB1.
Option D: Automatic tuning is a feature that automatically applies performance fixes to the SQL database. Automatic tuning detects and fixes the performance issues in the database, such as missing indexes, and performs index management, based on the workload. Therefore, the automatic tuning option is the most suitable solution for improving the performance of DB1 as it provides automated solutions for optimizing the SQL database without any administrative effort.
Therefore, the correct answer is D. Automatic tuning.
