Forum Discussion
High Memory usage in on-premise gateway server
All -
Hoping you can help, we have lately experienced high memory usage in our on-premise gateway server to the point that scheduled refreshes fail for datasets, (timeout errors). As a work around, we restart the gateway service nightly which seems to help some. The memory usage is related to the number of Mashup.Containers running. For example, after a service restart and at the start of the work day we'd have around a dozen or so of these Mashup.Containers running but by the end of the work day we have 100+ Mashup.Containers running, I've counted. The server is running 8 GBs of CPU and 16 GBs of RAM. We can add more memory but I fear that with the continual spawning of these Mashup.Containers the added memory would be over run. Are we missing a configuration setting to reuse Mashup.Containers or other configuration?
We are running the September 2020 version of the On-Premise Gateway
TIA
patw
HI pwillinger ,
There is a newer gateway (On-premises data gateway February 2021 update is now available | Microsoft Power BI Blog | Microsoft Power BI) I would first try to install that one and see if the world magically glows brightly and refreshes quickly! Let us know if that resolves it. If not, it gets a bit harder to start trying to figure out where the issue(s) may lie.
4 Replies
- collinq
Super User
HI pwillinger ,
There is a newer gateway (On-premises data gateway February 2021 update is now available | Microsoft Power BI Blog | Microsoft Power BI) I would first try to install that one and see if the world magically glows brightly and refreshes quickly! Let us know if that resolves it. If not, it gets a bit harder to start trying to figure out where the issue(s) may lie.
Thank you collinq. I thought I previously answered but no Reply appearing. Downloaded the February gateway install and will schedule an update, as this is prod. I was waiting on something newer than the Dec 2020 version. Hoping that a little magic fairy dust and rainbows will resolve.
Along this same note, what do you know/comment about...
MashupDefaultPoolContainerMaxCount
MashupDQPoolContainerMaxCount
...found in a search at https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance-cpu
patw
- collinq
Hi pwillinger ,
I found this thread where GilbertQ presented a quick blog post - Solved: Microsoft Mashup Container Evaluation - Microsoft Power BI Community I also found this article that has areference to what they do but I think it links back to the article that you mentioned 🙂 Power BI Performance Tuning Workflow - Part 2 - Microsoft Industry Blogs - United Kingdom
Sorry for not responding sooner, the March PowerBI Gateway did the trick. No more multiplying Mashup.Containers running and no need to nightly restart the Gateway service.
patw
