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 extra 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.