SQL AS 2005 SP2 maxes CPU and eats memory

[Ben Howard]

My OLAP cube times out on a fairly regular basis when modifying the time
dimenstion when it is used as a filter (ie selecting different periods etc).
The AS services (msdmsrv.exe) begins to max out the processor and uses over
1.3GB of RAM. The OWC pivot table times out and the whole server becomes
sluggish. The only was is to recycle msdmsrv.exe. Anyone seen this before
or got any good ideas as where to look to fix it (eg anything in the CU
updates).

 

[Gary L. Chefetz]

Ben:

Time manipulations with a high-volume of data or numeours dimensions in the
view have always been a touchy. Are there specific scenarios or combinations
of data that cause this? If so, can you do anything to skinny down the
dataset?

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

 

[Ben Howard]

In truth it's not that big a set of data - 80 projects, 2 PMs, 20 assignments
per project, time span = 24 months. I'll see what I can do re minimization
or upping the RAM in the box, plus installation of the latest CU for SQL
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

Ben:

Time manipulations with a high-volume of data or numeours dimensions in the
view have always been a touchy. Are there specific scenarios or combinations
of data that cause this? If so, can you do anything to skinny down the
dataset?

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com