Two days in a row I came in to see Ignition and SQLServer hung up, with 29/30 active connections being used, and the query age being 12+ hours.
During some testing the other day, I saw that some query errors were coming from the default setting of 8 connections being exceeded, so I bumped it up to 30. Before that, I never saw this error, so I took it down to 25 a few minutes ago. But, I need to know what was going on. Note that I couldn’t even open a table from SQL Server Management Studio either. In both cases I restarted the SQLServer service, and it came out of it.
Some of the queries in the connection pool were very short, but three of them were update queries containing fairly long strings (3000 characters). The tables don’t have very many rows, so I didn’t think indexing was the issue.
Any ideas what would cause the connection pool to fill up like this? It seems to happen all at once, and like I say, it just started happening when I increased the active connections. Are there some other parameters I should have changed at the same time?
Oh, I’m running SQLServer Express 2008 and Ignition 7.2.8(b178).