New memory and compute optimized hardware options in Azure SQL Database

Published Nov 04 2019 05:00 AM 6,250 Views
Microsoft

Now in preview, M-series and Fsv2-series are new hardware generations in Azure SQL Database specialized for workloads requiring very high compute or memory scale, or very fast CPU speed.  Gen5 in SQL Database continues to provide a balanced compute and memory option that is well-suited for typical workloads.

 

M-series: memory optimized hardware

M-series (preview) is a new memory optimized hardware option in SQL Database for workloads demanding more memory and higher compute limits than provided by Gen5.  M-series provides 29 GB per vcore and 128 vcores which increases the previous memory limit in SQL Database by 8x to nearly 4 TB.

 

Fsv2-series: compute optimized hardware

Fsv2-series (preview) is a new compute optimized hardware option in SQL Database delivering low CPU latency and high clock speed for the most CPU demanding workloads.  Depending on the workload, Fsv2-series can deliver more CPU performance per vcore than Gen5.  The 72 vcore size can also provide more CPU performance for less cost than 80 vcores on Gen5.  Note that Fsv2 provides less memory and tempdb per vcore than other hardware so workloads sensitive to those limits may want to consider Gen5 or M-series instead.

 

Learn more

5 Comments
Version history
Last update:
‎Nov 07 2019 11:13 AM
Updated by: