Hi all,

I'm using SQL2000 [32 bit] (service pack 4) on Window 2003 Server [32
bit] (service pack 1)on hardware EMT64, 2CPUs [64 bit]. In Analysis
Service, when I process a cube without other tasks running, sometimes
it uses all four threads. But sometimes, it uses only one thread. How
can I make it uses all four threads every time.

Best Regards,
Anote

If you are seeing all CPUs being used then it is an artifact of some other
activity. Partition and dimension process with SQL2K is single threaded for
the peak aggregation processing stage.

Look at using the Parallel Processing Utility found here:
http://www.microsoft.com/downloads/d...DisplayLang=en
If you want to load up the full system.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


<anote_un (AT) hotmail (DOT) com> wrote

Hmm, actually i didn't want to do the Parellel Processing.

For example, I process a cube in the morning it uses all CPU to do.
Then, I reprocess the same cube in the afternoon but it uses only one
thread to do so. There are no other activity running on the server.

Is there a bug of using AS 32 bit on Server 64 bit?

Thank you

reading data (particularly if AS and SQL are on the same server); but once
you enter the aggregation phase it should always be a single CPU. My guess
is that you've misinterpreted what is happening "in the morning". :-)
Something else is using those extra CPUs -- it is not Analysis Services.

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


<anote_un (AT) hotmail (DOT) com> wrote