Monitoring and tuning Azure SQL performance

DP-300 · Monitor, configure and optimize database resources · Updated

Use metrics, Query Store, Query Performance Insight, DMVs and automatic tuning to find and fix slow queries in Azure SQL.

This lesson is part of full DP-300 access

The first 2 DP-300 lessons are free. Full access opens every lesson with its practice questions, and the exam-style DP-300 question bank.

In this lesson
  • Layers of monitoring
  • Query Store
  • DMVs worth knowing
  • Tuning options
  • Scale when tuning is not enough
  • Exam traps
  • Practice questions

Get full access Try the free practice exam Log in

DP-300 course outline

All 6 lessons · Course overview
  1. Choosing the right Azure SQL optionPlan and implement data platform resources Free
  2. Migrating SQL Server to Azure SQLPlan and implement data platform resources Free
  3. Securing Azure SQL authentication and dataImplement a secure environment Full access
  4. Monitoring and tuning Azure SQL performanceMonitor, configure and optimize database resources Full access
  5. Automating tasks with elastic jobs, SQL Agent and AutomationConfigure and manage automation of tasks Full access
  6. High availability, disaster recovery and backupsPlan and configure a high availability and disaster recovery environment Full access