Hi all,
I'm running Analysis Services sp3 on a 64 bit machine. It's happened twice
that the CPU shoots up to 100% usage and doesn't come down with no users
logged on and no cubes being built. restart the service, it happens again.
Has anyone run into this? I've seen some threads on similar issues but our
environment doesn't match. -Thanks, Dave

Hi,

Have you looked with perfmon what is causing this, it could be wise to
contact PSS (MS Support) if this problem stays.

HTH,
Bas

Do you have any changing dimensions?
What you are describing sounds like the lazy aggregator kicking in because
you have flex aggs and you've done an incremental process of a changing
dimension. In which case, the system must recalculate the flex aggs and it
does this via a background thread.
Look here for a discussion of this and many other performance topics:
http://www.microsoft.com/technet/tre...e/ANSvcsPG.asp


--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"DWF" <dfateman (AT) memberworks (DOT) com> wrote