CODEWITHSUNDEEP
sql-serverssasssas-tabular
Luis Orozco
Luis Orozco

Reputation: 11

Enhancing Performance in SSAS Tabular Models with Physical Tables in SQL Server

I have an SSAS tabular model, and the tables are currently generated from SQL queries. I'm contemplating whether the performance would improve by using physical tables within SQL Server, as opposed to relying solely on tables generated by queries. Currently, all the tables in my model are query-based, and I'm considering the creation of these tables within the Datamart.

Thank you.

Upvotes: 1

Views: 287

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89361

If your tabular model is in DirectQuery mode, yes using tables (preferably columnstore tables) instead of complex queries is likely to improve performance significantly. But not as much as switching to Import mode would.

If you're already in Import mode it's possible that physical tables would improve the Import/Refresh performance. But they would not change the performance of users querying the Dataset at all.

Upvotes: -1

Related Questions