How to track peculiar hang problem of ASP based site?

[Manik Roy]

Hi,

I am having this peculiar hanging problem of my site.

About the site:
1) The site is an asp-based site with MSSQLServer as backend.
2) The database is in a separate windows 2000 m/c (in private network)
and the IIS is hosted by a windows 2000 m/c (in DMZ).
3) The site is running in the Medium(out-of-process pooled)
configuration.
4) We are using ADO to connect to SQL Server. We are using SqlOleDB and
TCP/IP to connect.

About the hang:
1) The hang occurs with no definite periodicity. Sometimes it occurs
after a week. Sometimes even twice a week.
2) During the hanged state, we are unable to run even simple asp pages
having no database connections. Html pages are served fine.
3) We need to always restart the DllHost_iwamm/c application to continue
operation.

Current Status and observations:
1) I have run performance monitor on it today when it is still running
ok. Users can log in and work. But the taskmanager and the perfmon logs
show that the Dllhost is consuming near 100% cpu usage. None of the
threads of this process was taking more than 30% of cpu.
2) The "ASP Requests Queued" counter was 24 and the "ASP Requests
Executing" counter was 44.
The "ASP Errors during Script Runtime" was around 411.
3) I have also run adplus tool on this state. The dump files were later
analyzed by WinDbg. The logs and dumps show no locks. All the threads
are in Unfrozen state.

What could be a possible strategy to find what is the reason of hanging
in this case?

With Kind Regards,
Manik

If you need further information, please let me know.


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Ray at]

I'm pasting in a quote from a reply to a similar query in .compononents.
This replay is from Pat [MSFT].

Ray at work


Next time it hangs, run IISState ([url]www.iisfaq.com/iisstate[/url]) against the
process that is serving your ASP pages. This will create a log file. If
you need help analyzing the log, you can post it to the group.

Most likely a COM object has hung the ASP worker threads.

iisstate -p <Pid of inetinfo or dllhost running the asp pages> <enter>

Pat



"Manik Roy" <mroy@duplexinfotech.com> wrote in message
news:eYCWJMT2DHA.2792@TK2MSFTNGP09.phx.gbl...

> Hi,
>
> I am having this peculiar hanging problem of my site.
>
> About the site:
> 1) The site is an asp-based site with MSSQLServer as backend.
> 2) The database is in a separate windows 2000 m/c (in private network)
> and the IIS is hosted by a windows 2000 m/c (in DMZ).
> 3) The site is running in the Medium(out-of-process pooled)
> configuration.
> 4) We are using ADO to connect to SQL Server. We are using SqlOleDB and
> TCP/IP to connect.
>
> About the hang:
> 1) The hang occurs with no definite periodicity. Sometimes it occurs
> after a week. Sometimes even twice a week.
> 2) During the hanged state, we are unable to run even simple asp pages
> having no database connections. Html pages are served fine.
> 3) We need to always restart the DllHost_iwamm/c application to continue
> operation.
>
> Current Status and observations:
> 1) I have run performance monitor on it today when it is still running
> ok. Users can log in and work. But the taskmanager and the perfmon logs
> show that the Dllhost is consuming near 100% cpu usage. None of the
> threads of this process was taking more than 30% of cpu.
> 2) The "ASP Requests Queued" counter was 24 and the "ASP Requests
> Executing" counter was 44.
> The "ASP Errors during Script Runtime" was around 411.
> 3) I have also run adplus tool on this state. The dump files were later
> analyzed by WinDbg. The logs and dumps show no locks. All the threads
> are in Unfrozen state.
>
> What could be a possible strategy to find what is the reason of hanging
> in this case?
>
> With Kind Regards,
> Manik
>
> If you need further information, please let me know.
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!