Summary
The Azure platform allows you to use the Azure Monitor to collect baseline performance data about both PaaS and IaaS resources. Within Windows, the Performance Monitor allows you to collect detailed performance information about your SQL Server. Azure SQL Database includes additional detailed query performance information through Query Performance Insight, and provides advanced monitoring capabilities through extended events.
Having a solid understand of the baseline workload of your server and database are critical to understanding performance anomalies.
Now that you've reviewed this module, you should be able to:
- Understand methods to review potential performance issues
- Identify critical Azure metrics
- Collect metrics for an established baseline
- Use extended events for performance analysis
- Understand Azure SQL Insights