SQL Database performance tuning tips

You can change the service tier of a standalone database or increase the eDTUs of an elastic pool at any time to improve performance, but you may want to identify opportunities to improve and optimize query performance first. Missing indexes and poorly optimized queries are common reasons for poor database performance. This article provides guidance for performance tuning in SQL Database.

If your Azure issue is not addressed in this article, visit the Azure forums on MSDN and the Stack Overflow. You can post your issue on these forums or to @AzureSupport on Twitter. Also, you can file an Azure support request by selecting Get support on the Azure support site.

Steps to evaluate and tune database performance

  1. In the Azure Portal, click SQL databases, select the database, and then use the Monitoring chart to look for resources approaching their maximum. DTU consumption is shown by default. Click Edit to change the time range and values shown.
  2. Use Query Performance Insight to evaluate the queries using DTUs, and then use SQL Database Advisor to view recommendations for creating and dropping indexes, parameterizing queries, and fixing schema issues.
  3. You can use dynamic management views (DMVs), Extended Events (Xevents), and the Query Store in SSMS to get performance parameters in real time. See the performance guidance topic for detailed monitoring and tuning tips.
Important

It is recommended that you always use the latest version of Management Studio to remain synchronized with updates to Microsoft Azure and SQL Database. Update SQL Server Management Studio.

Steps to improve database performance with more resources

  1. For standalone databases, you can change service tiers on-demand to improve database performance.
  2. For multiple databases, consider using elastic pools to scale resources automatically.