Forum Discussion
Memory configuration for Analysis Services / Vertipaq engine ?
There are details in the docs below on how to edit the msmdsrv.ini file for the Report Server SSAS instance
Also if you are running on a load balanced cluster you need to make sure you have followed all the steps in the following docs
Take special care to check the step on the backconnectionhostname setting. The first thing PBIRS does in uploading a file is to cache the file locally on c:\temp so if you don't have the backconnectionhostname property set properly the request to copy the file from the local temp folder to the database can fail as it can get "load balanced" to the other node where the cached file does not exist.
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.