Configure SQL Server resources for optimal performance

Data Analyst
Data Engineer
Database Administrator
Azure SQL Database
SQL Server

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

Learning 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


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