Forum Discussion

vitorp's avatar
vitorp
New Member
4 years ago
Solved

Gateway Low CPU and Memory Usage

Hi, my gateway is installed inside a VM with 36 vCPUs and 233GB of ram, there is nothing installed in this server, just my gateway.   The gateway is using 1~3% of CPU and about 2~4GB, i changed som...
Need Help
  • GilbertQ's avatar
    GilbertQ
    4 years ago

    Hi vitorp 

     

    I think to make it faster you need to get your Postgres server to return the queries faster. 


    The Gateway is just a throughput device between your Postgres server and the Power BI Service. I would suggest chatting to your DBA to see how they can increase query performance and through put.

GilbertQ's avatar
GilbertQ
Super User
4 years ago

Hi Anonymous 

 

I have to disagree with your statement, if you have a lot of Power Query transformation steps that will consume CPU on the Gateway Server.

 

Also depending on how many mashup containers you have configured to run in paralell and the size of each mashup container will cause an increase in memory on the gateway server.

 

The only time this wont be affected is if it is using DirectQuery or LiveConnection.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi GilbertQ ，

 

Yes! You're right!

 

I am sorry for my misunderstanding and thank you very much for making this clear to me😊.

 

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.