Azure Q&A #10 – Azure SQL and Improve Performance


Grammarly

More than 40 Lakhs Students and Professionals use Grammarly for their spell and grammar checks. You can register and try for free.

Problem

You have an Azure SQL database that contains multiple database tables in it. You are asked to improve the performance of the database with a reduced or minimized administrative effort.

Solution

Use the “automatic tuning” option in SQL Azure.

Azure SQL Database automatic tuning option 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.

Reference

Know more about automatic tuning in Azure SQL in the automatic tuning docs.


Grammarly

More than 40 Lakhs Students and Professionals use Grammarly for their spell and grammar checks. You can register and try for free.
%d bloggers like this: