SQL Server Performance Tuning and Optimization

SQT11 Performance Tuning and Troubleshooting Azure SQL Database

12/06/2016

4:15pm - 5:30pm

Level: Intermediate

Bradley Ball

Sr. Consultant – Premier Support for Developers

Microsoft

You are lost and you need help. You're using Azure SQL Database. Azure SQL Database seems like it's from Mars and everything you learned from the SQL box product is from Venus. Simple things like scaling hardware, collecting and interpreting perfmon counters, and diagnosing wait statistics just don't make sense anymore. This session will clearly define differences in performance tuning techniques, review concepts and draw comparisons to the regular SQL world you know and love. As a free bonus you get a tool bag of scripts to help you on your way.

You will learn:

  • How to correlate your experience in regular SQL to Azure SQL Database
  • How to determine when to scale up your Azure SQL Database
  • Steps to take to assess and troubleshoot your Azure SQL Database using the Azure Portal and T-SQL Scripts