|
Home > Archive > MS SQL Server OLAP > November 2005 > Olap Services closes with "out of memory" error once in few days.
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 |
Olap Services closes with "out of memory" error once in few days.
|
|
| Rukmani 2005-11-23, 7:24 am |
| 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
| |
| Seiko Pod 2005-11-23, 7:24 am |
| 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
| |
| Vladimir Chtepa 2005-11-23, 9:24 am |
| Hi, Rukmani
What is the Memory conservation threshold value on your AS2K?
Try to set the Memory conservation threshold 200-300 Mb fewer as it is now.
The AS2K halts self not in the boundary and it follows to out of memory
error.
Vladimir Chtepa
"Rukmani" <Rukmani@discussions.microsoft.com> schrieb im Newsbeitrag
news:FFC31720-40E7-4157-95B1- 37EDCF061A63@microso
ft.com...
> 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
| |
| Dave Wickert [MSFT] 2005-11-23, 8:24 pm |
| Another possibility is that the out-of-memory is being caused because of a
shortage of pagefile space. Increase the pagefile and/or add a secondary
page file.
This is talked about in the AS Operations Guide
http://www.microsoft.com/technet/pr...n/anservog.mspx
--
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rukmani" <Rukmani@discussions.microsoft.com> wrote in message
news:FFC31720-40E7-4157-95B1- 37EDCF061A63@microso
ft.com...
> 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
|
|
|
|
|