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