Home
Topics
Microsoft SQL Server Platforms
Microsoft SQL Server 2005
SQL Server error message: "Server out of memory"

SQL Server error message: "Server out of memory"

Greg Robidoux, Founder, Principal Database Engineer, Edgewood Solutions

My organization has a Sharepoint 2007 system with the database installed on SQL Server 2005. The content database gets corrupted and the Sharepoint gets strange errors. The only way to solve the problem is to restore the content database. Recently, another error, "server out of memory" has been occurring. The SQL Server process uses almost 2GB worth of memory, thus causing the Sharepoint application to become unavailable, with error messages indicating server out of memory.

A temporary fix to this problem is also restoring the content database from the last uncorrupted point. The SQL Server is going down every day and I can't keep restoring the database. Can you please help to get a permanent solution to this problem?

Requires Free Membership to View

Login

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

If the services are both running on the same server you should look at how much memory you are allocating SQL Server. It may be that SQL Server is trying to take as much memory as possible and causing other issues. I would look at this first.

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary
- Yukon

This was first published in September 2007

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- Real-time data analysis recipe calls for mix of IT, business savvy
  
  Business intelligence teams, IT managers and business executives need to come together to make real-time analytics initiatives effective.
- 'Big data' strains, stresses real-time business intelligence systems
  
  Incorporating big data adds to the complexity of developing real-time BI and analytics applications, partly due to the batch nature of big data tools.
- Real-time analytics brings BI data directly into business operations
  
  Giving end users immediate access to operational data for real-time business intelligence can help drive better decisions, if it fits business needs.
Data Center
- SDNs promise to shake up networking industry
  
  Big networking industry names and startups have jumped into virtualized networking, in hopes it will have the same impact as server virtualization.
- New automation, virtualization tools aid VM provisioning
  
  Increased automation and better tools are accelerating virtualization adoption and enhancing the approaches to VM provisioning.
- How time affects systems management planning
  
  Proper use of time is a critical consideration when it comes to systems management planning and responding to tasks.
Data Management
- 'Big data' in motion: Where does it make sense?
  
  Data architects creating operational business intelligence applications may put Hadoop 'big data' in motion using a fast messaging infrastructure.
- MDM drives Scotiabank mainframe modernization effort
  
  Mainframe-centric data models have given way to a master data management repository to support better compliance reporting at Scotiabank in Canada.
- Hadoop framework, big data systems will coexist with relational data in 2013
  
  Hadoop and NoSQL databases harness parallel processing to churn reams of big data. As 2013 dawns, interest is growing in mixing them with SQL tools.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Oracle
- Oracle database administrators assemble their 2013 Oracle wish list
  
  Oracle database administrators want to see better query optimization, memory leakage detection and heterogeneous support of Data Guard in 2013.
- Advanced Oracle analytics a major focus of BI summit
  
  Advanced Oracle analytics, including big data, NoSQL and the R programming language, will be a major focus of a BI summit to be held in the Bay Area in January, according to one of its organizers.
- Pluggable Database virtualizes Oracle Database 12c
  
  Several users beta testing Oracle Database 12c say that Pluggable Database is one of its most powerful new features.
Content Management
- Best practices in implementing an information governance policy
  
  Expert Barclay Blair describes how organizations struggling with data chaos can begin an information governance policy initiative to regain control.
- Structuring an enterprise-wide information governance policy
  
  This webcast explains how organizations can structure an information governance policy to help users find important information and tame data chaos.
- Webcast: Getting started with enterprise search technology
  
  This webcast explains enterprise search technology and offers advice on setting up search initiatives to help users find important information.
Windows Server
- Finding virtualization cost savings with Hyper-V 3.0
  
  With increasing dependence on high-performing hardware, it might be tough to find cost savings. Hyper-V and virtualization may be the answer.
- Deciding whether to run Server Core in Windows Server 2012
  
  Our expert breaks down the advantages and disadvantages of deploying Server Core in Windows Server 2012.
- Internet Explorer zero-day exploit overshadows light Patch Tuesday fixes
  
  Admins begin the new year with a light Patch Tuesday that includes two critical bulletins, but they'll also want to pay attention to an exploit in IE.

All Rights Reserved,Copyright 2005 - 2013, TechTarget