Limit of table sizes in SSAS?

ovonemty 51 Reputation points
2023-01-30T12:02:47.41+00:00

I am working on this cube:

User's image

Is there any limit in terms of size?

I have some big tables: 19M , 9M and 5M rows respectively. Is this within "normal" ?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,244 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,741 Reputation points
    2023-01-30T12:26:13.74+00:00

    I have some big tables: 19M , 9M and 5M rows respectively. Is this within "normal" ?

    That's not really "big" nowadays. We have fact table around 1,5 billion + 500 million rows; absolutly no problem for SSAS.

    Additional see Maximum capacity specifications (Analysis Services)

    0 comments
  2. Seeya Xi-MSFT 16,436 Reputation points
    2023-01-31T06:03:19.34+00:00

    Hi ovonemty,

    Yes. It is normal.

    It is documented in the article that Olaf mentioned.

    User's image

    If the limit is exceeded, there is always an error message. Analysis Services pre-allocates a modest amount of memory at startup so requests can be handled immediately. Additional memory is allocated as query and processing workloads increase.

    Best regards,

    Seeya

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments