Every time you attach to a database there is load on the probe and the database which is a problem when you have hundreds of databases each with 10-15 sensors.
I would like to see PRTG open one connection to the database and run the sql for all sensors under the database device. This would dramatically reduce CPU on the probe and hits on the database.
Even better yet would be an option that allows you to have a pooled connection that allows prtg to use the same open connection to query the database and re-open it if it is closed.
Article Comments
Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.
