Share via

SSAS tabular cube occupies RAM dynamically depending on server RAM size

V Anusha 0 Reputation points
2023-12-19T12:21:24.36+00:00

I have an SSAS tabular cube deployed on 2 servers. One server is having 512GB RAM (server1) and the other has 256GB RAM (server2). When we check the Memory details on task manager on both the servers, it shows 110GB (of 512GB) as occupied RAM on server1. On server2 is shows 80GB (of 256GB) as occupied RAM.

Size of cube = 69GB (taken from the properties window from SSMS in both servers)

Does cube occupy more RAM if server has high RAM even though cube size is same on both servers? Any thoughts, plz help!!!

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,248 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Greg Low 1,495 Reputation points Microsoft Regional Director
    2024-02-12T10:54:31.99+00:00

    Analysis Services loves memory. (Same as SQL Server itself) If there's more available, it will happily use it for caching, etc. That's a good thing that it uses the memory you paid for :-)
    You can set the limits by configuration settings on the server but it sounds like it's working as expected right now.
    BTW: we'd normally say "tabular data model" rather than "tabular cube" to distinguish them from the older multidimensional cubes.

    0 comments