The server is out of memory error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

The server is out of memory error

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.
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.
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
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.

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.
]]>