New memory and compute optimized hardware options in Azure SQL Database

This post has been republished via RSS; it originally appeared at: Azure SQL Database articles.

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

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.