IIS6 Slow

From: js (androidsun_at_yahoo.com)
Date: 05/14/04


Date: 13 May 2004 22:57:12 -0700

I have an intranet application running on Windows 2003 with IIS 6.
The application is written in traditional ASP. The database is on SQL
2000. I use MSXML4.0 to parse the query result in to XSLT. Most of
the time the performance is ok. However, when the query result is
more than 1000 rows, then things start to slowdown A LOT (more than 5
minutes). IE6 would take a long time before the final formated result
appears. Netscape7 would display the first 200 or so records then
continue rendering, not like IE showing blank page before all records
are rendered. The SQL server gets the result pretty fast (less then 2
seconds). I used the Performance Monitor on the Winodws 2003 Server.
Nothing seems to be extraordinary. I am not sure if the bottleneck is
in IIS 6 or the network or the client? The application performance on
IIS5 seems to be better than IIS6. Is there something that I missed
in IIS6 or Windows 2003 configuration, or the XML parser is not
optimized in my code? Could someone show me where to look? Thanks.



Relevant Pages

  • Re: IIS 6.0 and SQL server
    ... domain account, or it needs to be a local account on both machines with ... should be true both if you are using Windows authentication in SQL, ... if you are using SQL authentication in SQL but the SQL client on the IIS ...
    (microsoft.public.inetserver.iis.security)
  • Login failed for user (null)
    ... ISAPI dll) on a Windows 2000 Server (IIS 5.0) which is also a domain ... controller and has MS SQL 2000 installed. ... domain member and it doesn't work, but works fine when I do vice versa ...
    (microsoft.public.sqlserver.security)
  • Login failed for user (null)
    ... ISAPI dll) on a Windows 2000 Server (IIS 5.0) which is also a domain ... controller and has MS SQL 2000 installed. ... domain member and it doesn't work, but works fine when I do vice versa ...
    (microsoft.public.inetserver.iis.security)
  • Login failed for user (null)
    ... ISAPI dll) on a Windows 2000 Server (IIS 5.0) which is also a domain ... controller and has MS SQL 2000 installed. ... domain member and it doesn't work, but works fine when I do vice versa ...
    (microsoft.public.inetserver.asp.db)
  • Login failed for user (null)
    ... ISAPI dll) on a Windows 2000 Server (IIS 5.0) which is also a domain ... controller and has MS SQL 2000 installed. ... domain member and it doesn't work, but works fine when I do vice versa ...
    (microsoft.public.sqlserver.connect)