I am in charge of a server remotely using the remote desktop.
it seems that when the server gets a medium to large amount of traffic the connections to the database seem to break. I am using ODBC to connect to the database and by way of trial and error i have narrowed down that it must be this as other parts of the site that do not connect to the database via ODBC work alright still.
The error i get is an unspecified error at the first site of any database activity.
My question is this, is there any way to optimise the ODBC connections to deal a larger volume of traffic?
This isn't really a hardware question, more of a development question.
When you open a connection to a database in your code, you should be closing it when you are done with it. This practice will ensure that your connection pool will contain only the connections needed to operate your site, and consume only the needed resources as well.
this is where the page falls over and the server goes wrong, on the page this is the first place any database work is started.
when i get the error report from the server it says that the connection had timed out, so i will assume that that means that it couldnt create a connection within the alloted time which is 30 seconds (at least i think).
In order to over ride this problem i have to restart the server.
Im really lost with this, it seems to happen about once every 2 days or so.