Azure Analysis Services tabular model for 50 GB Data (Approx 99 Million Records))

Question

looking for recommendation to deploy 50 GB Data in Synapse Analytics (Approx 99 Million Records), Please suggest if Azure Analysis services S0 is capable of deploying and processing this volume of data.

Answer 1

Hello @Abhijeet Kumar , Thanks for the question and using MS Q&A platform.

While deciding the Tier, you should also consider the calculation which you are going to perform on the records. Let's say that if you are creating a formula on a column on all the 99 million, it will take up the compute and should be factored in. I doubt if S0 will suffice the ask as it only have 10 GB of memory, I think you can start with that and then Scale up. You can scale-up or down in the same tier from the portal.

https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-overview#standard-tier

Himanshu

Please accept as "Yes" if the answer provided is useful , so that you can help others in the community looking for remediation for similar issues.