Dear Forum,

We recently moved one of our busiest and most data intensive sites to a dedicated server (with other clint sites). We immediately noticed a drastic decline in performance.

I have spent several days, splitting up the busiest database into three smaller dbs. Additionally, I have gone back through many of our pages simplifying the queries or displaying data from queries within Access.

On the Shared server, we didn't see it bog down until we saw over 200 sessions per hour, now it craps out at less than a third of that traffic.

We are on a 2000 server with 512K RAM. Using Universal version
ASPDB2001.02.21.SP#.ADO21.MTS.Std

Any suggestions for improving performance would be greatly appreciated. Thanks in advance. Ted Moore