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

Abhijeet Kumar 0 Reputation points
2023-03-22T12:37:27.9533333+00:00

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.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
439 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
    2023-03-24T20:20:38.8+00:00

    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.