I came in this morning and opened up a client to look at a trend and it would never display the trend, I went into the database connections page and saw that there are 7 database connections open that refuse to close out. I closed all of the open clients and they still would not close. I’m not sure what the problem is here. Has anyone run into this before? (I’m using MSSQL 2005)
I checked the settings in the database and it seems like they are set to only allow a maximum of 5 idle connections but it seems like more are sitting there doing nothing. Not sure what to check next.
I checked the number of open connections on the database from Ignition at it is stuck at 27! Why are all of these database connections getting stuck open?