Every once in a while we get an "Out of Memory" error on our OLAP
Server and it's always with the same Database/Cube. I've been through
a round with MSFT on tuning and it still occurs.

Here's the interesting part. It only seems to get this error when
Processing the cube via a job running on the SQL Server box. If it
fails and you Process the cube using the Analysis Manager tool it
never fails. Don't tell me the memory situation was transitory and it
just happened to be running something at the time because I have had
someone monitoring memory when it failed and there was nothing else
running.

Any usefull suggestions would be appreciated.

There is a whole discussion of memory in the AS Operations Guide.
http://www.microsoft.com/technet/pro...e/anservog.asp
Did you take a look at it's recommendations?

In particular, it may be that doing the processing from some other interface
is effecting the use of the page file.
Also, were you closely monitoring the VM usage of the msmdsrv process? Is
there a particular threshold that is crossed when you get the error? Just
some suggestions.

--
Dave Wickert [MS]
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.


"brlarue" <ron.strouss (AT) westfarm (DOT) com> wrote

Thanks Dave ...

I took a look at the Operations Guide and started going through it.

We have looked at the memory while it runs, but not when it has
failed.

What's interesting is if you happen to catch the job right when it
fails and you rerun the jobstep it fails again. If you had switched
to an Analysis Manager(AM) window and Processed the cube through AM it
has always worked.

I have a ticket open again on this issue to see what they can uncover
this time. It may be a memory error, but I believe it's triggered by
processing the cube through a DTS package.

It's an intermittant error so it's hard to predict when it will occur.
We reprocess this cube every day.

On Mon, 16 Feb 2004 21:33:46 -0500, "Dave Wickert [MSFT]"
<dwickert (AT) online (DOT) microsoft.com> wrote: