How Speed of disk refreshing too factors into refresh time #1558
TinyTimothy2
started this conversation in
Data Modeling
Replies: 1 comment
-
|
There are no disk writes during refresh operations, as all data processing (compression, dictionary creation, etc.) happens in memory. As such, I don’t see how disk write speed could impact refresh performance. As a general rule, when sizing hardware for SSAS, get the fastest CPU and the fastest RAM available for your budget. That’s all that matters for SSAS tabular: https://www.sqlbi.com/blog/marco/2013/02/12/hardware-sizing-guide-for-ssas-tabular/ |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I have not seen this discussed before. How can we quantify how much the disk we write to factors in speed during a refresh?
Seems like that could be a potential bottleneck.
It is not clear if there are disks, log files that need dba attention or automated jobs to keep clean
ie
SSAS
Power BI RS
Beta Was this translation helpful? Give feedback.
All reactions