IIS 4.0 Is Very Slow

[tomk]

I have a PIII 500mhz server with 640mb of RAM running IIS 4.0 and SQL Server 7.0 (SP3). (The NT 4.0 software is on Service Pack 6).

Over the past couple of days the webserver has been very slow. There is nothing that I see that is taxing the machine. I completely uninstalled IIS and re-installed it with the same results.

Does anyone know what might make the webserver take minutes to display pages?

Any help is greatly appreciated.

Thanks,
Tom Komin

 

[Hal10K]

Tom:
You said:
>I have a PIII 500mhz server with 640mb of RAM running IIS 4.0 and SQL Server 7.0 (SP3). (The NT 4.0 software is on Service Pack 6).

SQL server (being a real memory intensive app) will take all of the memory it can get, unless you go into server properties and limit it. So, if you've got both SQL and IIS on the same box (a not recommended in SQL BOL) you'll need to tweak the settings on both applications and the server for best performance.

-hal

 

[Guest_imported]

SQL, from my understanding will take up ALL possible threads except for 1 (left for the kernel).

Therefore, running ANYTHING else would be nice and detrimental.

 

[tomk]

I actually found the problem. There was a scheduled task in Cold Fusion that was using SQL Server for hours at a time. I moved the site to a multiprocessor server and told SQL Server to only use one processor. It works great now --- even when the scheduled task is running since the other processor is free to run the other queries.

Thanks for everyone's input.

Tom