Post reply

3 Instances Limit Memory for each Instance

  • September 29, 2014 at 2:30 am

    #151381

    Which of the memory settings do I need to be concerned with. When trying to limit the amount of memory for a SSAS instance on my server.

    http://msdn.microsoft.com/en-us/library/ms174514(v=sql.110).aspx

    Thanks

  • September 29, 2014 at 2:47 am

    #1748735

    LowMemoryLimit: a dedicated amount of RAM for the SSAS instance.

    TotalMemoryLimit: when this is reached, SSAS will take measure to cut down on RAM usage. But SSAS can still go over this limit. This is by default 80% of the memory available.

    HardMemoryLimit: when this is reached, SSAS will cut connections to cut down on memory usage.

    HardMemoryLimit > TotalMemoryLimit.

    If you want to limit the amount of memory used by your instances, you need to configure at least HardMemoryLimit. I would set TotalMemoryLimit as well, just to make sure none of your users get disconnected. LowMemoryLimit can be useful to make sure an SSAS instance doesn't starve for memory.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • September 29, 2014 at 5:59 am

    #1748775

    Thanks, Very clear.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply