sql express perf spikes to 99%

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

William Stacey [C# MVP] - 08 May 2008 04:07 GMT

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.

Reply to this Message

Luther - 09 May 2008 17:20 GMT

On May 7, 8:07 pm, "William Stacey [C# MVP]"
<william.sta...@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.

Reply to this Message