MEAPSA

Describe performance monitoring

Compare Azure, and on-premises tools for monitoring and measuring performance. Determine critical metrics. Understand the purpose of a baseline for comparative analysis. Configure extended event sessions for tracing activities.

Data Analyst

Data Engineer

Database Administrator

Azure

SQL Server

SQL Database

Module Objectives

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.

Units

Introduction min
Describe performance monitoring tools min
Describe critical performance metrics min
Establish baseline metrics min
Explore extended events min
Describe Azure SQL Insights min
Explore Query Performance Insight min
Exercise: Isolate problems with monitoring min
Knowledge check min
Summary min

Prerequisites

Experience creating and configuring resources using the Azure portal.
Ability to use Windows Performance Monitor to monitor system components such as CPU, I/O, network traffic.