Azure Analysis Services preview update brings the ability to scale up and down

Reading time icon 1 min. read

Readers help support MSPoweruser. When you make a purchase using links on our site, we may earn an affiliate commission. Tooltip Icon

Read the affiliate disclosure page to find out how can you help MSPoweruser effortlessly and without spending any money. Read more

Built on the proven analytics engine in Microsoft SQL Server Analysis Services, Azure Analysis Services provides enterprise-grade data modeling in the cloud. It is compatible with the SQL Server 2016 Analysis Services Enterprise Edition and supports tabular models at the 1200 compatibility level. DirectQuery, partitions, row-level security, bi-directional relationships, and translations are all supported. Microsoft today announced a new update for the Azure Analysis Services preview that brings the ability to scale up or scale down the capacity of a server after it has been created.

For example, if there is a particular time of year when you expect query volume to be higher, you can simply scale the service up to get more QPUs. After that period is over, you can reduce your capacity by simply scaling down. The ability to scale up and down and adapt to changing workload demand is a one of the benefits of using Azure Analysis Services to host your models.

Learn more about this new feature here.

More about the topics: Azure Analysis Services, DirectQuery, Microsoft SQL Server Analysis Services, preview update, SQL Server 2016