RE: FN-FORUM: Dedicated Windows Managed Server?

date posted 19th April 2008 10:19

> This current server only has 1Gb RAM and is driving me nuts - nothing I
> do seems to improve the performance by much. Ha, ha. There are an average
> of 50 - 75 users per day on this web site - which has its own dedicated
> server and I count 22 timeouts today already - with the connection string
> set to "Connection Lifetime=300;"

I doubt whether another server will sort out your problems as a server with
1Gb of RAM should be able to easily server up pages to 50-75 users a day, I
suspect the code which is running on it is dubious, there is one key thing
which happened on a site I used to manage which sounds similar.

I found that the developer who originally created the site didn't always
close their database recordsets and connections properly, on every page the
correct classic ASP structure for example should be:

Dim objConn, objRS
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strConnString

Set objRS = Server.CreateObject("ADODB.RecordSet")
objRS.Open strSQL, objConn

...

objRS.Close
Set objRS = Nothing

objConn.Close
Set objConn = Nothing

I know it's a pain, but well worth the time spent as after sorting this out
on every page, most of the problems disappeared, upon further investigation
it turns out that unless you close the recordsets and connections like this
they remain in memory until they timeout.

HTH

--
Colin Shipton
Intrafusion Website Design & Development
http://www.intrafusion.co.uk
http://www.linkedin.com/in/intrafusion