Hi everyone,
I'm encountering significant performance degradation when querying large tabular models in SQL Server Analysis Services (SSAS). Queries that were once fast are now taking several minutes to complete, impacting user experience. The model size is around 10GB in memory.
I've already checked:
- Server resource utilization (CPU, RAM) - seems normal during query execution.
- Basic DAX query optimization - I'm using calculated columns sparingly and attempting to write efficient measures.
Has anyone faced similar issues and found solutions? I'm looking for advice on specific areas to investigate, such as partitioning, DAX patterns to avoid, or even hardware considerations.
Any insights would be greatly appreciated!