sql express perf spikes to 99%

[William Stacey [C# MVP]]

I installed BCM shared db on Server 2005. 2 Vista clients and 1 XP pro. I
have noticed sql instance in task manager is spiking cpu to 95-99% daily for
long periods that brings machine to a crawl. This is even when nobody is
using BCM. I can't diag anything because no profiler in express. What
could this be? Anyone see this behavior? tia.

 

[Luther]

I installed BCM shared db on Server 2005.  2 Vista clients and 1 XP pro. I
have noticed sql instance in task manager is spiking cpu to 95-99% daily for
long periods that brings machine to a crawl.  This is even when nobody is
using BCM.  I can't diag anything because no profiler in express.  What
could this be?  Anyone see this behavior?  tia.

My first guess is that Windows Desktop Search on the clients is
indexing the BCM data. If it settles down after a few days, that was
probably the cause.