MEAPSA

Explore causes of performance issues

Explore the Query Store for tracking down problematic queries. Understand how SQL Server and Azure SQL manage currency by locking and blocking, or by using snapshots. Implement fragmentation checks and defragmentation.

Data Analyst

Database Administrator

Data Engineer

Azure

SQL Server

SQL Database

Module Objectives

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

Units

Introduction min
Describe SQL Server Query Store min
Describe blocking and locking in SQL Server min
Describe data file fragmentation min
Exercise: Identify and resolve blocking issues min
Knowledge check min
Summary min

Prerequisites

Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
Experience creating and configuring resources using the Azure portal.
Basic understanding of SQL Server file storage.