Query Performance Tuning Techniques For Windows Azure SQL Database
Just because you're using an Azure SQL database does not mean you can avoid tuning queries. You could run into throttling which could seriously impact your systems if your queries are using up lots of resources. Plus, it's still SQL Server, and the number one cause of performance bottlenecks is usually T-SQL code. This session introduces you to the tools you have available to identify poor performing queries, such as dynamic management objects and monitoring tools in the Azure Portal. Learn how to understand why a query is running slow using the Azure Portal execution plans. This understanding will enable you to fix your poorly performing queries.