locked
Unloading a Tabular model from the SSAS istance RRS feed

  • Question

  • Hi,

    I'm asking to unload a Tabular model from memory without detaching it from the SSAS instance.

    This could be more useful in scenarios where the SQL engine is present on the same machine that hosts the SSAS instance, in order to stop temporarily the tabular model to dedicated resources for somewhat ETL processings.

    Any helps to me, please?

    Thanks

    Wednesday, December 18, 2013 3:00 PM

Answers

  • Hi,You can stop the tabular service during ETL processing.

    One way to calculate the size of the tabular model in memory can be to take the total file size of the model  x 2 . If that is only a small part of total available physical memory You might ignore the impact.

    A good blog post about memory settings in Tabular is here:

    http://www.sqlbi.com/articles/memory-settings-in-tabular-instances-of-analysis-services

    Thomas Ivarsson

    • Proposed as answer by Charlie Liao Thursday, December 19, 2013 9:29 AM
    • Marked as answer by Charlie Liao Thursday, December 26, 2013 1:50 PM
    Wednesday, December 18, 2013 6:20 PM
  • I see two possibilities. First, you might connect to SSAS Management Studio, right click on the server node and choose Properties, the lower LowMemoryLimit and TotalMemoryLimit and VertiPaqMemoryLimit temporarily. Instead of clicking OK you can click the script button and save the script to automate this. Lower SSAS memory during the ETL and raise it before model processing. The second option is to restart the SSAS service. Then SSAS will use very little memory until someone connects causing that database to be loaded into memory. Just beware you don't have Management Studio open and connected to SSAS during this as it will cause all SSAS databases to load into memory.

    http://artisconsulting.com/Blogs/GregGalloway

    • Marked as answer by Charlie Liao Thursday, December 26, 2013 1:50 PM
    Sunday, December 22, 2013 12:09 AM

All replies

  • Hi,You can stop the tabular service during ETL processing.

    One way to calculate the size of the tabular model in memory can be to take the total file size of the model  x 2 . If that is only a small part of total available physical memory You might ignore the impact.

    A good blog post about memory settings in Tabular is here:

    http://www.sqlbi.com/articles/memory-settings-in-tabular-instances-of-analysis-services

    Thomas Ivarsson

    • Proposed as answer by Charlie Liao Thursday, December 19, 2013 9:29 AM
    • Marked as answer by Charlie Liao Thursday, December 26, 2013 1:50 PM
    Wednesday, December 18, 2013 6:20 PM
  • I see two possibilities. First, you might connect to SSAS Management Studio, right click on the server node and choose Properties, the lower LowMemoryLimit and TotalMemoryLimit and VertiPaqMemoryLimit temporarily. Instead of clicking OK you can click the script button and save the script to automate this. Lower SSAS memory during the ETL and raise it before model processing. The second option is to restart the SSAS service. Then SSAS will use very little memory until someone connects causing that database to be loaded into memory. Just beware you don't have Management Studio open and connected to SSAS during this as it will cause all SSAS databases to load into memory.

    http://artisconsulting.com/Blogs/GregGalloway

    • Marked as answer by Charlie Liao Thursday, December 26, 2013 1:50 PM
    Sunday, December 22, 2013 12:09 AM