Forum Discussion
Memory configuration for Analysis Services / Vertipaq engine ?
Thanks d_gosbell for your answer ! We are doing these NLB configuration checks right now, keep you posted.
By the way, do you know if this high paging rate of msmdsrv is a normal behavior ? Isn't it supposed to consume the available memory on the server instead of paging ? Let me precise that nothing else Power BI Report Server runs on these VMs, and RAM usage is less than 35%.
Based on https://docs.microsoft.com/en-us/analysis-services/server-properties/memory-properties I would like to try setting the paging policy to 0, but I am open to any advice here!
Here is the memory settings we have, default values I presume:
<Memory>
<MemoryHeapType>-1</MemoryHeapType>
<HeapTypeForObjects>-1</HeapTypeForObjects>
<HardMemoryLimit>85</HardMemoryLimit>
<TotalMemoryLimit>70</TotalMemoryLimit>
<LowMemoryLimit>60</LowMemoryLimit>
<VertiPaqMemoryLimit>0</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>
<HeapTypeForObjectGroupCount>0</HeapTypeForObjectGroupCount>
<UseCountersPerCPU>-1</UseCountersPerCPU>
</Memory>
Thanks again for your help,
Silvère
slhermite wrote:
By the way, do you know if this high paging rate of msmdsrv is a normal behavior ? Isn't it supposed to consume the available memory on the server instead of paging ?
It's hard to say as I'm not sure which counters you are looking at or what the rate is. But in general I would not expect to see a lot of paging from the msmdsrv process unless it is under memory pressure which it does not sound like it is in your case.