The application has been developed by a third party vendor.
The problem we see when a report is shown in the application it is not releasing DB connections immediately.
When we run "sp_iqconnection" we see the DB connections still exist and gets released after 5 or 10 minutes.
We can run "DROP CONNECTION" command to release DB connection immediately, but we need to know on
what basis a DB connection can be released? Whether it can be Idle time of the connection or by any other parameter?
Also how do we find that the connection has done its job and pulled the data from Database.