I've been having an odd problem recently where I end up building up lots of connections to the YAF database (seemingly even when there aren't more than on or two users accessing it). It takes about a day to go from one connection to over a hundred (and all users are the same) and it seriously impacts the performance of the server. To get it to work again, I have to kill all the connections to the database (by setting mode to single_user and then back to multi_user) and restart the application pool - but then the next day it's back to the same thing. This seemed to happen out of the blue and I can't figure it out. Is there some reason YAF would be opening so many connections and not closing them?

It's version "1.9.3.3 alpha". I can indeed change the connection lifetime setting in the connection string, but there's still a connection leak somewhere. I figure that there must be an exception occurring somewhere before the connection is closed, but I'm not sure how to find it.

This is still going on. I've set the Connection Lifetime and Connect Timeout to very low numbers but it doesn't seem to make a difference. I'm seeing >100 connections after only a few hours and my server slows to a grind.. This is even with nobody using the forum. I don't understand it.. out of dozens of databases on this server the YAF database is the only one with this problem.