Power Bi Enterprise Gateway 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.