Managing and tuning the performance of relational databases is a challenging task that requires significant expertise and time investment but now we have another tool in our arsenal to help us optimize our relational workloads.
Query Performance Insight allows you to spend less time troubleshooting database performance by providing the following:
- Deeper insight into your databases resource (DTU) consumption.
- The top DTU consuming queries, which can potentially be tuned for improved performance.
- The ability to drill down into the details of a query.
For more information, visit the Query Performance Insight page on MSDN