Azure VM sizes range from a single virtual CPU with 768MB of RAM all the way up to 416 CPUs with nearly 12TB of RAM, ... When you run SQL Server on Azure, you have a couple of options.

SQL Server on Azure Virtual Machines in practice. When leading London-based firm Atrium Underwriters wanted to modernize its over 800 databases, it turned to Microsoft for help.

By distributing the SQL Server nodes across separate AZs, we qualify for Azure’s 99.99% SLA for virtual machines, ensuring resilience against hardware failures and zone outages.

Azure Dedicated Host will support Windows, Linux and SQL Server virtual machines and pricing is per host, independent of the number of virtual machines you end up running on them.