MS SQL Server OLAP - Re: Olap Services closes with "out of memory" error once in few da

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Olap Services closes with "out of memory" error once in few da

Rukmani

2005-11-23, 7:24 am

Hi Seiko,

This is issue is not specific to SP3a. We are struggling with this problem
for a year now, since SQL2000 and no SP. One of the solutions was to setup
move to W2K Enterprise edition and /3G switch to help increase Virtual Byte
limit to 3G. This does not work, as we still get error at 2G.

I also saw post here reporting similar problems with SP4.
I see memory increase mostly during online access. Actually, there is
memory usage increase/decrease during and after cube processing, but only
increase during online access.

Has Microsoft confirmed this problem is fixed in SP4 ? The patch Q887596
did not help.

Thanks,
Rukmani

"Seiko Pod" wrote:

> I have experienced the same problems.
>
> It seems that SQL 2K SP3a has a memory leak and doesn't release memory
> after processing cubes.
> I suggest you get the new SP4 for AS and the AWE HotFix.
>
> Rukmani wrote:
>
>

Sponsored Links