I don't care whether it comes back or not, but it isn't going to prevent the 'too many connections' error.
When that happens, it is almost ALWAYS at 2 mins past the hour, there is no way that the number of guests could cause that sort of problem. The only thing that could cause that is some sort of scheduled task being performed on the server, delaying sql queries and causing a build up of connections. It obviously takes a couple of minutes for these to build up to the 'too many connections' error.
VB needs to talk to Jon and find out what is run 'on the hour' and determine if there is anything that can be done so prevent them overloading the server in the way they do.
Bookmarks