sql express perf spikes to 99%%
  Home FAQ Contact Sign in
microsoft.public.outlook.bcm only
 
Advanced search
POPULAR GROUPS

more...

microsoft.public.outlook.bcm Profile…
 Up
sql express perf spikes to 99%%         


Author: William Stacey [C# MVP]
Date: May 7, 2008 20:07

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.
1 Comment
Re: sql express perf spikes to 99%%         


Author: Luther
Date: May 9, 2008 09:20

On May 7, 8:07 pm, "William Stacey [C# MVP]"
gmail.com> wrote:
> 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.
no comments