SQL Server Performance

The server is out of memory error

Discussion in 'Analysis Services/Data Warehousing' started by Praveen, Dec 28, 2004.

  1. Praveen New Member

    Hi,
    Following error occurs while retreving data from cubes.
    "The server is out of memory."
    While retreving data from cubes analysis server takes lots of memory and it does not release memory.
    How to overcome this error? What server side settings are required?
    Analysis server configuration is 2.4GHz speed, 3 GB RAM, 4 processors.

    Thanks and Regards,
    Praveen Patil.
  2. Luis Martin Moderator

    What OS, SQL ans SP do you have installed?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  3. Raulie New Member

    Yes there are server settings you need to take into account. I can spend about an hour going back and forth on these settings, but better yet read the Ops Guide under Configuratin Management/Memory&gt<img src='/community/emoticons/emotion-4.gif' alt=';P' />aging Files&gt;Memory and get all the details.<br /><br /<a target="_blank" href=http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx#ETAA>http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx#ETAA</a><br /><br />Raulie<br />Hewlett-Packard Company
  4. Praveen New Member

    Analysis server config - OS is Windows 2000 Advanced Server, 100 GB HD, Microsoft SQL Server 2000 - 8.00.760, Service Pack 4.


    quote:Originally posted by LuisMartin

    What OS, SQL ans SP do you have installed?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.


  5. satya Moderator

    Check the service pack on Analysis server not on the SQL server, there will be a seperate Service Pack for this service.

    Check Raulie's reference ahout the configuration settings.
    And it will be a good start to investigate the problem by collecting PERFMON stats for Memory, Cpu, physical disk etc. during the process to assess the situatio.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page