Describe performance monitoring

Intermediate
Data Analyst
Data Engineer
Database Administrator
Azure
Azure SQL Database
SQL Server

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.

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

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.