Summary

Completed

Proper storage configuration is important to the performance of your Azure Virtual Machines. SQL Server should run on premium disk storage or ultra disk for optimal performance. You can use the Resource Provider for SQL Server to automate the creation of your storage for you SQL Servers on Azure Virtual Machines. You can used Resource Governor to manage differing workloads in the same SQL Server.

Now that you've reviewed this module, you should be able to:

  • Understand your options for configuration of Azure storage

  • Describe how to configure tempdb data files in SQL Server

  • Describe how to choose the right type of virtual machine for SQL Server workloads

  • Understand the use cases and configuration of Resource Governor in SQL Server