SQL Server Administration and Maintenance

SQW01 SQL Server on Azure VMs: The Important Details


9:15am - 10:30am

Level: Intermediate

Thomas LaRock

Head Geek


Microsoft Azure Virtual Machines is a robust infrastructure for Microsoft SQL Server, providing the full benefits of infrastructure-as-a-service offering in Microsoft data centers. SQL Server in a Microsoft Azure Virtual Machine has a low overall TCO and makes an efficient platform for enterprise level workloads. This session examines the critical facets beyond the mere provisioning of the SQL VM, and looks at the characteristics and considerations for tuning, optimizing, and the key indicators for monitoring performance. We look at special considerations for High-Availability and Disaster Recovery, and pay special attention to scalability.

You will learn:

  • How to configure SQL Server running in an Azure VM
  • How to performance tune SQL Server in an Azure VM
  • How to weight cost, benefits, and risk with regards to HA/DR options when using SQL Server in an Azure VM