sql express perf spikes to 99%

  • Thread starter Thread starter William Stacey [C# MVP]
  • Start date Start date
W

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.
 
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.
Click to expand...

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.
 
Back
Top