如何估算Azure分析服务内存 [英] How to estimate Azure Analysis Service Memory

问题描述

亲爱的团队，

您能帮我为我的用例选择适当的AAS层吗? .

Could you help me to choose the appropriate AAS tier for my use case. Any help to calculate/estimate the AAS memory from my underlying data is appreciated.

问题:

1. SQL Server DW与AAS之间的压缩率是多少? (我们在SQL DW数据之上构建AAS多维数据集)；以及如何估计AAS内存?

1. What is the compression ratio between SQL Server DW Vs AAS? (We build AAS Cube on top of a SQL DW data); And how to estimate AAS memory?

2. AAS支持的最大行数是多少?

2. What is the maximum no of rows supported by AAS?

3. AAS(最大S9级-400GB内存)足以应付以下用例.尤其是对于非加性指标.

3. AAS (Maximum tier S9 -400GB Memory) is good enough to handle the following use case. Especially for Non Additive Metrics.

   选项1:3年内300亿行(根据最低的谷物计算AAS中的不同计数)

   Option 1: 3,00,000 Million rows for 3 years (Calculate distinct count in AAS from lowest Grain)

   选项2:3年内80亿行(预先计算所有组合的ETL中的非重复计数并存储在Azure SQL DW中)

    Option 2: 8,000 Million rows for 3 years (Pre calculate distinct count in ETL for all combination and store in Azure SQL DW)

Liyasker Samraj K

Liyasker Samraj K

推荐答案

您好，Liyasker，

Hi Liyasker,

您可能会发现此线程有帮助:

You might find this thread helpful:

这篇关于如何估算Azure分析服务内存的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！