Do the remote database agents keep a persistent connection open between the FMS and the Database being monitored or does the agent open a connection only when the agent starts its collection cycle and then closes the collection after the collection?
The remote database agents keep at least 3 persistent open connections to the Database being monitored at all times. This is the way the Foglight agent is designed.
The logic behind this design is that establishing new connections each time the agent starts its collection cycle takes up valuable resources which be substantial since there are many collection with different time interval between them.
Please refer to KB 98559 for more details on database agent connections.
