Forum Discussion
Power Bi Enterprise Gateway Memory Usage
It seems that the Enterprise Gateway service is a memory hog and is dramatically slowing our production server down. Does anyone know if it is possible to limit it's memory usage similiar to the way you can restrict MSSQL memory usage?
Adjust gateway performance based on server CPU | Microsoft Docs has info on this, but your gateway should not be on the production SQL server. That server should dedicate 100% of resources to Power BI.
The gateway should be on a separate machine (not a domain controller) where memory is available or even a beefy workstation. See On-premises data gateway sizing - Power BI | Microsoft Docs for sizing recommendations.
But pull it off of the database server. That will slow the server down, or radically slow the report refreshes down, or both.Ok. I'll mark that as a solution. But remember that a gateway does not need to be on a server. Buy a cheap desktop with 16-32GB of RAM, install Windows 10 on it, install the gateway and call it a day.
5 Replies
Adjust gateway performance based on server CPU | Microsoft Docs has info on this, but your gateway should not be on the production SQL server. That server should dedicate 100% of resources to Power BI.
The gateway should be on a separate machine (not a domain controller) where memory is available or even a beefy workstation. See On-premises data gateway sizing - Power BI | Microsoft Docs for sizing recommendations.
But pull it off of the database server. That will slow the server down, or radically slow the report refreshes down, or both.Thanks for your response.
But, we do not have another machine where we can put the gateway on to. We are small organisation and only running a VPS which is hosted with a third party provider. Basically, we have one server running IIS, MSSQL and PowerBi.
I'll review the link you provided on adjusting gateway performance, hopefully that helps.Ok. I'll mark that as a solution. But remember that a gateway does not need to be on a server. Buy a cheap desktop with 16-32GB of RAM, install Windows 10 on it, install the gateway and call it a day.
