I have an application running version 7.2.8. We have a redundant setup of ignition servers and a separate MS SQL Server for history data. Every couple of weeks we have to restart the Ignition service because we accumulate enough hanging queries that we max out our number of active connections. Here is a screen shot of the DB Connection monitor so you can see what I mean:
This image only shows 2 hanging queries right now, but these connections will stay open for over a week. These hanging connections will just accumulate at a rate of 1 every 2-3 days until there are 8 of them. At that point all trending breaks and we have to restart the gateway service in order to restore functionality.
Any idea why I would have queries that hang for days on end?
Is this a case where the connection testing under the connection configuration would be useful? I have looked for documentation about the idle connection evictor but have come up empty handed in the forum and the online documentation.