Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Monitor and optimize operational resources in Azure SQL

Microsoft via Microsoft Learn

Overview

  • Module 1: Describe performance monitoring
  • After completing this module, you will be able 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 Database Intelligent Insights.
  • Module 2: Explore causes of performance issues
  • After completing this module, you will be able to:

    • Understand the purpose and benefits of the Query Store
    • Investigate the available reports and data in the Query Store
    • Observe the impact of forcing execution plan selection
    • Learn how blocking and locking work in the SQL Server database engine
    • Learn about database isolation levels
    • Gain understanding of database fragmentation and its impact
  • Module 3: Configure SQL Server resources for optimal performance
  • After completing this module, you will be able to:

    • Understand your options for configuration of Azure storage
    • Learn how to configure TempDB data files in SQL Server
    • Learn how to choose the right type of VM for SQL Server workloads
    • Understand the use cases and configuration of Resource Governor in SQL Server
  • Module 4: Control database-level configuration options. Explore Intelligent Query Processing. Configure Open Source databases for optimum performance.
  • After completing this module, you will be able to:

    • Configure Database Scoped Configuration Options
    • Understand the features of Intelligent Query Processing
    • Explore performance monitoring options in Azure Database for PostgreSQL and MySQL
  • Module 5: Describe performance-related maintenance tasks in SQL Server
  • After completing this module, you will be able to:

    • Implement maintenance tasks for indexing and statistics
    • Gain insight on plan forcing
    • Explore the auto-tuning feature in Azure

Syllabus

  • Module 1: Describe performance monitoring
    • Introduction
    • Describe performance monitoring tools
    • Describe critical performance metrics
    • Establish baseline metrics
    • Explore extended events
    • Describe Azure Intelligent Insights
    • Exercise: Isolate problems with monitoring
    • Knowledge check
    • Summary
  • Module 2: Explore causes of performance issues
    • Introduction
    • Describe SQL Server Query Store
    • Describe blocking and locking in SQL Server
    • Describe data file fragmentation
    • Exercise: Identify and resolve blocking issues
    • Knowledge check
    • Summary
  • Module 3: Configure SQL Server resources for optimal performance
    • Introduction
    • Explain how to optimize Azure storage for SQL Server virtual machines
    • Describe virtual machine resizing
    • Optimize database storage
    • Control SQL Server resources
    • Knowledge check
    • Summary
  • Module 4: Configure databases for performance
    • Introduction
    • Describe database scoped configuration options
    • Describe intelligent query processing
    • Describe query store in Azure Database for MySQL and PostgreSQL
    • Knowledge check
    • Summary
  • Module 5: Describe performance-related maintenance tasks in SQL Server
    • Introduction
    • Maintain indexes
    • Maintain statistics
    • Describe automatic tuning
    • Exercise: Detect and correct fragmentation issues
    • Knowledge check
    • Summary

Reviews

Start your review of Monitor and optimize operational resources in Azure SQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.