DLLHOST.EXE & 100% CPU Usage

[TheFitz]

All,

Here is a problem for you. Over the past month or so, one of our servers has started to peak at 100% CPU when we access the web pages.

I have checked the following:

There have been no software updates
There are no viruses on the machine
No extra members

We are using MS Access XP (2002 format) databases for the system and these were updated relatively recently, however we believe that this is not the problem.

Strangely enought, we have a team which were working in the system over night and they didn't have any problems. However, at about 6:30 this morning the system slowed right down and web pages started to fail due to timeouts on the system.

As far as I can tell, no new users came onto the system at 6:30 this morning.

Any ideas?? This one's been baffling me for ages.

Happy Holidays to All.

Many thanks in advance,

Fitz.

Fitz
Did you know, there are 10 types of people in this world:
* Those who understand binary
and
* Those who Don't!!

 

[Sheco]

Are there perhaps any scheduled tasks that kick off at 6:30?

Does the CPU drop back down if you Stop the IIS service?

 

[TheFitz]

There are no Scheduled Tasks running and the when you stop IIS it DOES drop CPU to nothing much.

Fitz
Did you know, there are 10 types of people in this world:
* Those who understand binary
and
* Those who Don't!!

 

[Sheco]

Does it happen for all pages or only certain pages?

 

[TheFitz]

It seems to happen on pages that Access to DB's that we are using.

Fitz
Did you know, there are 10 types of people in this world:
* Those who understand binary
and
* Those who Don't!!

 

[DotNetGnat]

make sure that you are closing all the db connections and recordset objects and set them to nothing...

-DNG

 

[Sheco]

Perhaps there is an inefficient query that contains a cross-product?

This is the kind of thing that can slip thru during development and testing because lets say you have only 10 rows while testing then your cross-product gives you 10x10=100 rows in memory... during testing you might have 1,000 rows so 1000x1000 = 1,000,000 rows in memory... then once you go live you might end up with 100,000 rows giving a cross-product of 10,000,000,000 (ten billion) and all of a sudden your performance goes to squat.