3Monitor, Configure, and Optimize Database Resources

• 3.1Monitoring and Performance Visibility

  Understand monitoring Azure SQL—metrics (DTU/CPU/IO), Azure Monitor / Log Analytics, Query Store, and dynamic management views (DMVs)—to find performance bottlenecks.

• 3.2Query and Index Optimization

  Understand reading execution plans, indexes (missing/unused/fragmentation), statistics, and optimization via automatic tuning and intelligent query processing. After measuring comes improving.