Performance Tuning in Azure SQL Database by Monica Rathbun

Title: Performance Tuning in Azure SQL Database

Have you moved to a cloud database like Azure SQL Database and are having performance issues? While the Azure SQL services running in Azure are similar to SQL Server, they are key differences in performance tuning methodologies. In this session, you will learn about monitoring options, changes in cloud DMVs, and additional cloud tuning tools like Azure SQL Analytics and Performance Insights that can allow you quickly get to performance data across a number of instances. You will learn about what you need to keep in mind when choosing between scaling-out to readable secondaries and scaling-up to higher tier solutions. Discuss with Microsoft MVP Monica Rathbun the challenges and benefits of tuning, what to keep in mind, and what to expect in the cloud.
Goals: Learn how to navigate Azure SQL Database Portal for performance information How to configure Azure SQL Analytics How to find problem queries in Azure SQL Database
Prerequisites: Basic Knowledge of Azure SQL Database Understanding of Queries Understanding of troubleshooting