[SSAS]Estimate database size - moxuemeivip/Microsoft-Analysis-Service-Or-Fabric GitHub Wiki

Named SSAS instance AS\LULUSSAS, from SSMS we can get this instance running with two databases:

image

image

SSMS Estimated Size:

image

We can find the db file from this directory:

C:\Program Files\Microsoft SQL Server\MSAS16.LULUSSAS\OLAP\Data

image

C:\Program Files\Microsoft SQL Server\MSAS16.LULUSSAS\OLAP\Data\Adventure Works Internet Sales Model.2.db

File Size on disk:

image

Run following windows command to get detailed file sturcture and export the result to a file with name olap_data_202504.txt:

  1. Run command prompt as admin
  2. Go to the db folder by cd C:\Program Files\Microsoft SQL Server\MSAS16.LULUSSAS\OLAP\Data\Adventure Works Internet Sales Model.2.db
  3. run dir /s >olap_data_202504.txt image

image

image