A
Aaron McAlpine
Our production system developed a problem over the Thanksgiving weekend.
Wednesday evening... everything is fine. First thing Monday morning, we
started receiving complaints about the system being "slow".
I found that the web application will clip along without a problem and then,
for no apparent reason, it will "hang" for 15 to 30 seconds before returning
the page to the client. It appears that the http request is submitted to the
server and it "sits" on it. After it's released, the SQL query executes and
the page returns. There are no messages appearing in the windows event logs
(application, security, system), and I do not beleive that the worker
process is being recycled because users are not losing session state
(InProc).
I theorize that the problem is with ASP.Net because:
SQL Profiler shows normal response from SQL Server (once the query is
executed)
Evaluations of the network performance show no problems
Classic ASP pages are fine
The environment is:
Corporate intranet only (Windows authentication)
Win2k Server SP4
IIS 5.0
ASP.Net 1.0/ASP.Net 1.1 side-by-side (all apps are currently configured
to use 1.0)
Some classic ASP remains in the application
SQL Server 2000 SP3
I've tried a SQL Server restart/iisreset as well as a server reboot. I've
excluded inetpub\wwwroot from our antivirus (MacAfee) real-time monitor.
I've also tried using the application trace tool (trace.axd) but it doesn't
really show me anything useful for this situation.
This is severly hampering productivity for my users, but I don't know what
to do next to try and trace the problem. Is there a known issue that I've
not been able to track down? Are there any other tools out there that may
help me to see what's going on with the ASP.Net worker process.
Thanks in advance.
Wednesday evening... everything is fine. First thing Monday morning, we
started receiving complaints about the system being "slow".
I found that the web application will clip along without a problem and then,
for no apparent reason, it will "hang" for 15 to 30 seconds before returning
the page to the client. It appears that the http request is submitted to the
server and it "sits" on it. After it's released, the SQL query executes and
the page returns. There are no messages appearing in the windows event logs
(application, security, system), and I do not beleive that the worker
process is being recycled because users are not losing session state
(InProc).
I theorize that the problem is with ASP.Net because:
SQL Profiler shows normal response from SQL Server (once the query is
executed)
Evaluations of the network performance show no problems
Classic ASP pages are fine
The environment is:
Corporate intranet only (Windows authentication)
Win2k Server SP4
IIS 5.0
ASP.Net 1.0/ASP.Net 1.1 side-by-side (all apps are currently configured
to use 1.0)
Some classic ASP remains in the application
SQL Server 2000 SP3
I've tried a SQL Server restart/iisreset as well as a server reboot. I've
excluded inetpub\wwwroot from our antivirus (MacAfee) real-time monitor.
I've also tried using the application trace tool (trace.axd) but it doesn't
really show me anything useful for this situation.
This is severly hampering productivity for my users, but I don't know what
to do next to try and trace the problem. Is there a known issue that I've
not been able to track down? Are there any other tools out there that may
help me to see what's going on with the ASP.Net worker process.
Thanks in advance.