I have a problem with slow-loading ASP pages on my Windows 2003 Server, which is hosted by a hosting company in a data center. I have looked at some of the other solutions suggested and have implemented them:
1. Added Response.Buffer = True to the connection file.
2. Stopped Windows Indexing Service.
Both of these things seemed to help somewhat, but the pages still load too slowly. This is sporadic - they don't always load slowly, but only sometimes. Many of the pages pull data out of an MS SQL database, which could of course be the bottleneck. However, it is not only pages that display data from the database but pages that don't that load slowly. Sometimes the pages will load almost instantly, and other times they can take up to 20 seconds. I don't get a timeout error - it just takes forever for the page to load.
I had a look at the memory and CPU usage in the Task Manager, and the tasks that are taking a lot of memory are w3wp.exe, ReportingServicesServices.exe, sqlserver.exe, MCShield.exe (this is the Mcaffee virus scan program), and services.exe. The biggest memory user is sqlserver.exe, which is using almost 7 MB of memory. CPU usage is mostly between 0-3%, but jumps occasionaly to 30-40% and once jumped to 50% while I was watching it. I tried doing a search which requires heavy-duty database querying, and it caused CPU usage to jump momentarily by about 10%, but didn't seem to have any effect on memory. The Commit Charge stays around 1900/3945 M.
Here is some more info about the server:
PROCESSOR: Intel Xeon 3060 - 2 x 2.4GHz Cores
MEMORY: 2 GB
DISK: 2 x 250GB SATA II
UPLINK: 100 Mbps Public & Private Networks
OPERATING SYSTEM: Windows Server 2003 Standard R2 (32 bit)
If possible, I would like to avoid having to buy more memory from the hosting company as that is quite expensive. However, if it turns out that is really the problem I will have no choice.