How can be Foglight be installed to monitor SQL Server database instances on hosts in a DMZ?
解决办法
There are two options available to monitor a SQL Server host located in the DMZ outside of an internal firewall.
Install a Foglight Agent Manager in the DMZ and then have the FglAM communicate with the hosts also in the DMZ. A port would be required to be opened then from the Agent Manager back to the FMS (for example 8080, or 8443) to send the http data, as well as using an On-Demand Data Port (e.g. 3723 for Oracle, 3235 for SQL Server, 3260 for Azure SQL) for ad hoc queries, and a SQL PI repository port (default 1433, but this could also be a custom port).
Allow the FglAM inside corporate network to communicate through the firewall to the hosts in the DMZ. In those situations, the DB server port (e.g. 1433) and the OS monitoring ports (e.g. WMI, or WinRM port 80, 443, etc) would be opened between in the DMZ firewall between the FglAM and the hosts. The FglAM and PI repository would then also communicate to each other inside the firewall.
