MEAPSA

Configure databases for optimal performance

Implement tasks for both IaaS and PaaS to maintain indexes, and statistics. Explore the automatic tuning features of Azure SQL Database. Control database-level configuration options. Explore Intelligent Query Processing.

Data Analyst

Data Engineer

Database Administrator

Azure

SQL Server

SQL Database

Module Objectives

After completing this module, you will be able to:

Understand database scoped configuration options
Understand maintenance tasks related to indexing and statistics
Understand the features of Intelligent Query Processing (IQP)
Explore the automatic tuning feature in Azure

Units

Introduction min
Explore database maintenance checks min
Describe database scoped configuration options min
Describe automatic tuning min
Describe intelligent query processing min
Exercise: Detect and correct fragmentation 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 structure and usage of SQL Server indexes.