Blog Post

Azure SQL Blog
2 MIN READ

GA of new memory and compute optimized hardware options in Azure SQL Database

Morgan_Oslake's avatar
Morgan_Oslake
Icon for Microsoft rankMicrosoft
Jul 23, 2020

Now released for general availability (GA), 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.  M-series and Fsv2-series are supported for both single database and elastic pool deployments.  Gen5 hardware in SQL Database continues to provide balanced compute and memory option that is well-suited for typical workloads.   

 

M-series: memory optimized hardware  

M-series 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 up to 128 vcores which increases the previous memory limit in SQL Database by 8x to nearly 4 TB.  Also, now available are smaller M-series compute sizes starting from 8 vcores on up for workloads requiring less total CPU and memory, but still providing the same high memory-to-vcore ratio for less cost. 

 

Fsv2-series: compute optimized hardware  

Fsv2-series 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.  Also, now available are smaller Fsv2-series compute sizes starting from 8 vcores on up for workloads requiring less total CPU and memory, but still providing the same low CPU latency and high clock speed per vcore for less cost.  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 

Updated Jul 23, 2020
Version 1.0
  • Support for M-series in the General Purpose tier is under future consideration.  Fsv2-series is unlikely to be supported in the Business Critical tier primarily due to scarcity of local disk space required for higher IO performance.  (All General Purpose tier options in SQL DB use remote storage for database data.)

  • Support in the future for a memory optimized hardware option in SQL DB Hyperscale is under consideration. 

  • Johannes_Vink's avatar
    Johannes_Vink
    Brass Contributor

    Any plans on moving the M-series to the General Purpose tier and the Fsv2-series to Business Critical?

  • Maneesh1980's avatar
    Maneesh1980
    Copper Contributor

    M-series

     Important

    For Azure SQL Database, M-series hardware has been retired and is not available for new deployments.

    Existing customers should migrate to other hardware tiers before September 2023.

    M-series is only supported in the Business Critical tier and does not support zone redundancy