We are using w2k advanced server and olso using SQL 2000 with service Pack
4. Our Analayse server also service pack 4. when we process cubes in
Analaysis manager our server CPU usage %100. After restart the server
everything is ok. before restart the server I could'd kill msmdsrv.exe and
it use %100 of CPU. What can I do to solve this problem? I Could't find
anything related with my problem. Please, help me !!!

Perhaps some of the MS people can point you in a specific direction.

However - the MSMDSRV is the olap server itself - and when processing cubes
it will use lots of resources - but you should get that back when trying to
query to cube afterwards. However - If processing is too demanding my guess
is that it could be related to your dimension / cube structures. And that's
a large area....

http://www.microsoft.com/technet/pro.../ansvcspg.mspx

"Serkan Yukselir" <serkan1907 (AT) hotmail (DOT) com> wrote

Check if you have any cube using Lazy Aggregations.

"michael v" wrote: