Hanging ASP and DLLHOST.exe

[Ben]

I have intermittent problems with asp pages timing out. When this happens, my DLLHOST.exe runs away with all of my CPU for about 2-3 minutes. As I understand it, this component executes asp requests in a COM server on IIS. I am not using any custom COM objects in my app, but lots of ADO. Could this be a memory leak with my use of ADO, or is this caused by something else? If it is a memory issue, I can start tracking it down. I just need to know what the possible issues/causes could be to get started troubleshooting

Thank

Ben

 

[Aaron [SQL Server MVP]]

http://www.aspfaq.com/2227

--
http://www.aspfaq.com/
(Reverse address to reply.)

I have intermittent problems with asp pages timing out. When this

happens, my DLLHOST.exe runs away with all of my CPU for about 2-3 minutes.
As I understand it, this component executes asp requests in a COM server on
IIS. I am not using any custom COM objects in my app, but lots of ADO.
Could this be a memory leak with my use of ADO, or is this caused by
something else? If it is a memory issue, I can start tracking it down. I
just need to know what the possible issues/causes could be to get started
troubleshooting.

 

[Alan Howard]

Do you have MoveNext calls in all of your Recordset loops?

I have intermittent problems with asp pages timing out. When this

happens, my DLLHOST.exe runs away with all of my CPU for about 2-3 minutes.
As I understand it, this component executes asp requests in a COM server on
IIS. I am not using any custom COM objects in my app, but lots of ADO.
Could this be a memory leak with my use of ADO, or is this caused by
something else? If it is a memory issue, I can start tracking it down. I
just need to know what the possible issues/causes could be to get started
troubleshooting.

 

[Egbert Nierop \(MVP for IIS\)]

Do you have MoveNext calls in all of your Recordset loops?


happens, my DLLHOST.exe runs away with all of my CPU for about 2-3 minutes.
As I understand it, this component executes asp requests in a COM server on
IIS. I am not using any custom COM objects in my app, but lots of ADO.
Could this be a memory leak with my use of ADO, or is this caused by
something else? If it is a memory issue, I can start tracking it down. I
just need to know what the possible issues/causes could be to get started
troubleshooting.

In addition, it could be a SQL server deadlock or a table scan on a table
with hundreds of thousands of records, which means that the SQL needs to be
optimized.

 

[Ben]

Doh! Thanks Alan - that took care of one of the pages. I checked others where this is happening and it looks like other loops are constructed correctly. Any other thoughts on how this could be caused?

 

[Aaron [SQL Server MVP]]

Did you look at http://www.aspfaq.com/2227 ?

 

[Ben]

I did - although it turns out it was a combination of poorly constructed loops and other type mismatch errors from earlier in the page that were not handled, I will check the configuration also. Thanks all