Forum Discussion
SSH Tunnel
that's a loaded question. Guidance for gateways differs massively depending on the expected workload. Direct Query connections require (ultra) fast network interfaces. Import Mode connections require 16+ GB of memory and ample compute cores and available disk space. Do not try to put a gateway onto a VM that also does other stuff (like a SQL Server instance) - they will make each other's lives miserable.
Another guidance - place your gateway VM as close as possible to your main data sources to reduce the impact of network lag.
Thank you for the help. If I may, Ill ask one more follow up, as I am trying to figure out the path ill take helping others with cloud based servers.
If not on my machine, what would be the best way to set up the gateway? Is there a best practice here? Thank you again
Super Userthat's a loaded question. Guidance for gateways differs massively depending on the expected workload. Direct Query connections require (ultra) fast network interfaces. Import Mode connections require 16+ GB of memory and ample compute cores and available disk space. Do not try to put a gateway onto a VM that also does other stuff (like a SQL Server instance) - they will make each other's lives miserable.
Another guidance - place your gateway VM as close as possible to your main data sources to reduce the impact of network lag.
Appreciate all the help sir