Monitor and improve performance

Azure SQL Database identifies potential problems in your database and recommends actions that can improve performance of your workload by providing intelligent tuning actions and recommendations.

Performance tuning options

Performance tuning options available Azure SQL Database are available on the database navigation menu under "Intelligent Performance":

Performance tuning option Single database and pooled database support Instance database support
Performance overview - Monitor all performance activities for your database. Yes No
Performance recommendations - Shows performance recommendations that can improve performance of your workload. Yes No
Query Performance Insight - Shows performance of top consuming queries on the database. Yes No
Automatic tuning - Use Azure SQL Database to automatically optimize your database performance. Yes No

Performance overview

This view provides a summary of your database performance, and helps you with performance tuning and troubleshooting.

Performance overview for Azure SQL Database

  • The Recommendations tile provides a breakdown of tuning recommendations for your database (top three recommendations are shown if there are more). Clicking this tile takes you to Performance recommendations.
  • The Tuning activity tile provides a summary of the ongoing and completed tuning actions for your database, giving you a quick view into the history of tuning activity. Clicking this tile takes you to the full tuning history view for your database.
  • The Auto-tuning tile shows the auto-tuning configuration for your database (tuning options that are automatically applied to your database). Clicking this tile opens the automation configuration dialog.
  • The Database queries tile shows the summary of the query performance for your database (overall DTU usage and top resource consuming queries). Clicking this tile takes you to Query Performance Insight.

Performance recommendations

This page provides intelligent tuning recommendations that can improve your database's performance. The following types of recommendations are shown on this page:

  • Recommendations on which indexes to create or drop.
  • Recommendations when schema issues are identified in the database.
  • Recommendations when queries can benefit from parameterized queries.

Performance recommendations for Azure SQL Database

You can also find complete history of tuning actions that were applied in the past.

Learn how to find an apply performance recommendations in Find and apply performance recommendations article.

Query Performance Insight

Query Performance Insight allows you to spend less time troubleshooting database performance by providing:

  • Deeper insight into your databases resource (DTU) consumption.

  • The top CPU consuming queries, which can potentially be tuned for improved performance.

  • The ability to drill down into the details of a query.

    Query Performance Insights for Azure SQL Database

Find more information about this page in the article How to use Query Performance Insight.

Automatic tuning

Azure SQL databases can automatically tune database performance by applying performance recommendations. To enable it, read how to enable automatic tuning.

Automatic tuning for Azure SQL Database

To learn more, read Automatic tuning article.

Additional resources