Memory high using SSAS tabular

Question

I am using SSAS Tabular and the size of database is not big, and also users not much using ssas.

But my memory used is 98%. My memory already 64G.

Can you give me tips to reduce the memory ?

Answer 1

Try this post from Kasper Dejonge. Basically he gives you an excel spreadsheet with powerpivot. You connect it to your SSAS instance and it will show you the memory used by table/column. With it, We've reduced memory use and process time.