MEAPSA

Configure SQL Server resources for optimal performance

Choose the appropriate size and storage options for your Azure SQL databases. Configure server resources such as tempdb. Understand the usage of Resource Governor.

Data Analyst

Data Engineer

Database Administrator

Azure

SQL Server

SQL Database

Module Objectives

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

Units

Introduction min
Explain how to optimize Azure storage for SQL Server virtual machines min
Describe virtual machine resizing min
Optimize database storage min
Control SQL Server resources 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.
Knowledge of purpose of SQL Server system databases: master, tempdb, msdb
Basic understanding of SQL Server file storage.