Re: Olap Services closes with "out of memory" error once in few days.
- From: "Seiko Pod" <maben@xxxxxxxxxxxxx>
- Date: 23 Nov 2005 01:54:43 -0800
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:
> Hi,
>
> We are running SQL 2K SP3a on a W2K3 machine. We use OLAP Services to
> create cubes and serve as Datamart. Once in a few days, OLAP services
> shutsdown or restarts by itself giving out "out of memory" error. Mostly it
> occurs while processing the cubes, but at times during the day as well. We
> have to restart Analysis services after which the cubes gets processed.
>
> I have run Perfmon. There is plenty of available memory. The error occurs
> when "virtual Bytes" of MSMDSRV.EXE becomes > 2G. We have enabled /3G
> switch, increased "memory threshold", and have also applied the hotfix
> Q887596.
>
> Perfmon shows the Virtual Bytes of MSMDSRV.EXE is ever increasing during
> online access. It shoots to maximum while cube processing, but drops down,
> though not to the previous level.
>
> Any solutions please ?
>
> Thanks,
> Rukmani
.
- Prev by Date: Re: HTTP Access to AS 2005 not working
- Next by Date: Cube security using DSO
- Previous by thread: Key Performance Indicators : SSAS 2005
- Next by thread: Re: Olap Services closes with "out of memory" error once in few da
- Index(es):
Relevant Pages
|
