locked
size of tabular cube RRS feed

  • General discussion

  • I don't see any DMV which gives the size of the tabular cube.
    Or how can we retrieve the sizes of all tabular models in SSAS tabular server.
    i searched online but no luck .Could you help with that?
    Tuesday, March 15, 2016 11:44 PM

All replies

  • Hi Chaitanya

    You can use DISCOVER_OBJECT_MEMORY_USAGE  to get the memory size of the various objects in your tabular cube

    select * from $system.discover_object_memory_usage

    * execute as a MDX query against your Tabular database

    you can also read this MSDN article for more DMV's.

    Alternatively you can use Vertipaq Analyzer which is a free tool by SQLBI that you can use to analyse your model and will give you all the information you are looking for and more..

    Wednesday, March 16, 2016 11:49 AM
  • Hi Michael

    discover_object_memory_usage doesn't give actual tabular model size.
    and there is no proper information online.
    I have got update in other thread that there are no dmv's to get the size of the cube.
    Anyways i will try to use the Vertipaq analyzer and see if that helps

    Thank You
    Chaitanya

    Friday, March 18, 2016 7:12 PM