SSAS Memory Settings - 2008R2 64 BIT Enterprise

Question

SSAS Memory Settings - 2008R2 64 BIT Enterprise

curious_sqldba

SSC-Dedicated

Points: 36494
More actions
August 22, 2016 at 1:03 pm

#149059

I haven't really played with memory settings on SSAS engine so is the question. Under the properities it is set to 65 and 80 for Lowmemory and totalmemory respectively. I am looking in the .ini file, i do not see Lowmemory and Highmemory variables. What should i be modifying? I looked around couldn't find exactly what i was looking for.

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

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

PB_BI SSCoach Points: 17461 More actions · Answer 1

curious_sqldba (8/22/2016)
I haven't really played with memory settings on SSAS engine so is the question. Under the properities it is set to 65 and 80 for Lowmemory and totalmemory respectively. I am looking in the .ini file, i do not see Lowmemory and Highmemory variables. What should i be modifying? I looked around couldn't find exactly what i was looking for.

In the .ini file it's in this bit:

<Memory>

<MemoryHeapType>2</MemoryHeapType>

<HeapTypeForObjects>0</HeapTypeForObjects>

<HardMemoryLimit>0</HardMemoryLimit>

<TotalMemoryLimit>80</TotalMemoryLimit>

<LowMemoryLimit>65</LowMemoryLimit>

<VertiPaqMemoryLimit>60</VertiPaqMemoryLimit>

<MidMemoryPrice>10</MidMemoryPrice>

<HighMemoryPrice>1000</HighMemoryPrice>

<VirtualMemoryLimit>80</VirtualMemoryLimit>

<SessionMemoryLimit>50</SessionMemoryLimit>

<MinimumAllocatedMemory>25</MinimumAllocatedMemory>

<WaitCountIfHighMemory>10</WaitCountIfHighMemory>

<DefaultPagesCountToReuse>2</DefaultPagesCountToReuse>

<HandleIA64AlignmentFaults>0</HandleIA64AlignmentFaults>

<PreAllocate>0</PreAllocate>

<VertiPaqPagingPolicy>1</VertiPaqPagingPolicy>

<PagePoolRestrictNumaNode>0</PagePoolRestrictNumaNode>

</Memory>

You can edit it in the file itself or in the SSMS properties page, it's up to you. Careful though, do some research on these values before changing them and be aware that you need to restart the service after changing them for them to come into effect.

I'm on LinkedIn

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 2

PB_BI (8/23/2016)
curious_sqldba (8/22/2016)
I haven't really played with memory settings on SSAS engine so is the question. Under the properities it is set to 65 and 80 for Lowmemory and totalmemory respectively. I am looking in the .ini file, i do not see Lowmemory and Highmemory variables. What should i be modifying? I looked around couldn't find exactly what i was looking for.
In the .ini file it's in this bit:
<Memory>
<MemoryHeapType>2</MemoryHeapType>
<HeapTypeForObjects>0</HeapTypeForObjects>
<HardMemoryLimit>0</HardMemoryLimit>
<TotalMemoryLimit>80</TotalMemoryLimit>
<LowMemoryLimit>65</LowMemoryLimit>
<VertiPaqMemoryLimit>60</VertiPaqMemoryLimit>
<MidMemoryPrice>10</MidMemoryPrice>
<HighMemoryPrice>1000</HighMemoryPrice>
<VirtualMemoryLimit>80</VirtualMemoryLimit>
<SessionMemoryLimit>50</SessionMemoryLimit>
<MinimumAllocatedMemory>25</MinimumAllocatedMemory>
<WaitCountIfHighMemory>10</WaitCountIfHighMemory>
<DefaultPagesCountToReuse>2</DefaultPagesCountToReuse>
<HandleIA64AlignmentFaults>0</HandleIA64AlignmentFaults>
<PreAllocate>0</PreAllocate>
<VertiPaqPagingPolicy>1</VertiPaqPagingPolicy>
<PagePoolRestrictNumaNode>0</PagePoolRestrictNumaNode>
</Memory>
You can edit it in the file itself or in the SSMS properties page, it's up to you. Careful though, do some research on these values before changing them and be aware that you need to restart the service after changing them for them to come into effect.

Thanks . Looks like only hardmemorylimit can be changed through SSMS and other two needs to be modified in .ini file.

PB_BI SSCoach Points: 17461 More actions · Answer 3

Most of it should be - did you try clicking on the "Show Advanced (All) Properties" checkbox on the properties page?

I'm on LinkedIn