High Memory usage in on-premise gateway server

[pwillinger]

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

[pwillinger]

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

[collinq · Accepted solution]

HI @pwillinger ,

There is a newer gateway (On-premises data gateway February 2021 update is now available | Microsoft Power BI Blog | Microsoft...)  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.

[pwillinger]

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