A few months ago I started an ASP based website hosted on an NT server with a
remote hosting service. Their NT servers run NT 4, Service Pack 6. My QA box
that I use for development runs Windows 2000. A couple of weeks ago I uploaded
the most complex portion of the site. Complex in the sense that of the 8 ASP
pages which comprise it, there are about eight open recordsets from the database,
as compared to the other pages which make up the site and have only 1-3
recordsets. I didnot think that the amount of recordsets in the complex portion
was too many, but thoroughly tested it on my QA box (not only is it running Win
2000, but it is a PIII 1 Ghz, w/ 256 mb of RAM) to make sure it was ok. Having
tested it, I uploaded it to the remote server, however, performance became
unacceptable. The average response time of a page in the complex portion had
been just over 3-4 seconds on my QA box, but on the remote server it jumped to 3-
5 minutes. Needless to say, the pages timed out. After running several tests
with the remote hosting company, I have concluded that it must be a difference
between IIS under Win 2000 and under NT 4. One of the QA people at the remote
hosting service copied the whole siteand put it on a local NT 4 box. When
accessing the complex portion, load times were still from 3-5 minutes. The only
difference between the machine he was running on and my QA box was the OS. Do
you know of any specific issues with performance between IIS under NT 4 and IIS
under Win 2000 that would cause this, or anything that could possibly help me fix
the problem? The web hosting service does not want to move to Windows 2000 at
this time. Thanks for any help or ideas.