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

Tech-Archive recommends: Speed Up your PC by fixing your registry

Look at the AS Performance Guide.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ansvcspg.mspx
in Appendix C -- which does a suspend and a resume against a cube. That
flushes out the query cache.
--
Dave Wickert [MSFT]
dwickert@xxxxxxxxxxxxxxxxxxxx
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Ashok" <Ashok@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:70163CEB-0251-449E-A112-ABDB4A898099@xxxxxxxxxxxxxxxx
> Hi Guys,
> We have same problem while processing cubes memory goes up and then comes
> back close to normal but once users start querying cubes using Excel 2002
> (Pivot table) client memory goes up and stays up at one level then next
> day
> if we don't reset AS service it fails (Out of memory) at the time of cube
> processing...I hope it's not Excel.
>
> If you find any solution please post.
>
> Thank you - Ashok
>
> "RJ Smith" wrote:
>
>> I'd still try adding pagefile. There isn't anything in the application
>> settings that's going to effect the available RAM to AS -- AS is
>> large-addressable aware -- that's compiled into the EXE. Also, triple
>> check
>> your boot.ini file to make the switch is for the right config, is spelled
>> /3GB, not /3G, etc. Also, try putting the AS memory under a microscope
>> with
>> more perfmon process counters and/or system memory counters and see if
>> you
>> can determine what's going on there.
>>
>> Something's preventing AS from getting the full 3GB of memory. You can
>> tweak
>> the registry setting for AS to try to prevent it from running out of
>> memory,
>> most notably the processing memory setting, as this is usually when AS
>> runs
>> out of memory, particularly if you're processing anything in parallel,
>> but
>> those won't have any effect on the actual memory (2GB vs. 3GB) that's
>> made
>> available by the OS to the server.
>>
>> BTW, AS doesn't use AWE -- that's a relational SQL buffer thing. AS uses
>> minimal buffers during data reads, and tweaking that setting has little
>> effect on AS performance overall.
>>
>> --RJ
>>
>> "Rukmani" <Rukmani@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:AB741254-1E5A-4883-BE52-B162862EEFFD@xxxxxxxxxxxxxxxx
>> > Hi Dave,
>> > Our server has 6G RAM, and the pagefile is 4G. At the time of error,
>> > %Usage of the pagefile is 1%, where as it has gone to 1.2% at other
>> > times.
>> > %UsagePeak of pagefile is 1.4%.
>> >
>> > Thanks,
>> > Rukmani
>> > "Dave Wickert [MSFT]" wrote:
>> >
>> >> 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/prodtechnol/sql/2000/maintain/anservog.mspx
>> >>
>> >> --
>> >> Dave Wickert [MSFT]
>> >> dwickert@xxxxxxxxxxxxxxxxxxxx
>> >> 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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:FFC31720-40E7-4157-95B1-37EDCF061A63@xxxxxxxxxxxxxxxx
>> >> > 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
>> >>
>> >>
>> >>
>>
>>
>>


.

Relevant Pages