Introduction
A major part of the job of a database administrator is proper performance monitoring. This task does not change when moving to a cloud platform. While Azure offers tools for monitoring, you may lack some specific controls around hardware that you would have in an on-premises environment which makes understanding how to identify and resolve performance bottlenecks while in Azure SQL that is much more critical.
Learning objectives
- Understanding methods to review potential performance issues
- Identify critical Azure metrics
- Learn how to collect metrics for an established baseline
- Use extended events for performance analysis
- Understand Azure SQL Insights