Forum Discussion

lubosst's avatar
lubosst
Frequent Visitor
5 years ago
Solved

PBI On Premise Data Gateway Errors (minimizing using system resources)

Hi, I was playing with gateway settings to help our server, which is not the fastest one. I try to modify MemoryUtilizationPercentageThreshold and CPUUtilizationPercentageThreshold and set them to 60...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hilubosst，

     

    Gateway sizing recommendations depend on many variables. like Cache data workloads,Live Connection and DirectQuery workloads.

    We provide you with general recommendations that you can take into consideration.

    For more information，you can refer to this：On-premises data gateway sizing  

     

    On the other hand，enable addtional logging setting  will increase the log size significantly, based on gateway usage. We recommend that after you finish reviewing the logs that you disable additional logging. We don't recommend leaving this setting enabled during normal gateway usage.

     

    Hope it helps.

     

    Best Regards,

    Caitlyn Yan

     

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

     

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

"What recommendations do you have to minimize system resources for Gateway?"

 

You're holding it wrong.  You want "moar power", not less.  Use a gateway cluster with multiple cluster members. Each cluster member should have at least 4 cores (better 8), at least 8GB RAM (better 32) and ample of fast disk space.