问题描述
亲爱的团队，
您能帮我为我的用例选择适当的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
推荐答案
您可能会发现此线程有帮助:
You might find this thread helpful:
这篇关于如何估算Azure分析服务内存的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！