Monitor and optimize operational resources in Azure SQL

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

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