none
How to Improve performance of Tabular Model RRS feed

  • Question

  • Hi,

    Can you please give some tips to improve performance of tabular cube

    Thanks and regards,

    Prudhvi

    Thursday, November 1, 2018 7:03 AM

All replies

  • see

    https://www.sqlshack.com/performance-tuning-an-ssas-tabular-model/


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Thursday, November 1, 2018 7:31 AM
  • We should take care some of the key concepts to achieve overall performance

    Relational Database

    1. Proper relational database design
    2. Create star schema for better performance (dimension & facts)
    3. Table partitioning at least for facts having lot of data
    4. if you have a lot of calculations then try doing them in the relational database itself
    5. Keep data & log files on separate drives and use fastest drives for better I/O

    SSAS Multidimensional/Tabular

    Dimensions

    1. Create Surrogate keys in dimensions
    2. Try to create natural hierarchies (so better transform your data initially)
    3. Consider only required attributes
    4. Create attribute relationships
    5. Use key/value/name column properties properly 

    Cubes

    1. Create Partitions 
    2. Try avoiding many small partitions in a single measure group
    3. Create aggregations though avoid too many of them


    Cheers,


    • Edited by Amit-Tomar Thursday, November 1, 2018 8:30 AM
    • Proposed as answer by Pirlo Zhang Monday, November 5, 2018 1:51 AM
    Thursday, November 1, 2018 8:30 AM