API Database Connection Not Closing

Hi all,

I am having problems with an database connection. I am currently using version 11, creating traditional apps for internal use only.

I have a simple aggregate which returns the latest exchange rate from an entity based of currency and date. I have exposed an API which is converting a currency based on the latest exchange rate.

I am consuming this API in another application. Whenever this API is called, the correct results are returned however, the database connection to the table remains open. There is nothing unusual about this query or API. I have developed other APIs which don't seem to be experiencing this issue.

Because the connection remains open, this is having a huge impact on the CPU utilization of the SQL server.

Has anyone experienced this issue, or no how I can resolve this?

Many thanks,
Asha

You can try to set a lower timeout setting for your connections.