How does Appfluent monitor the data warehouse workload? How much overhead does it add?
The query workload is monitored by a component called a ‘Watcher’ that is either installed on the database server or the application server. The Watcher runs as a daemon (Unix) or a service (Windows) and monitors the query workload by ‘packet sniffing’ the traffic on the network ports. Since the monitoring is via network packet sniffing, the Watcher is designed to run 24/7 with negligible overhead on the production server. All other processes are typical run on a non-production server.
