SQL Server error message: "Server out of memory"

Edgewood Solutions

Avoid restoring your SQL Server database to solve the SQL Server error message "server out of memory." The problem could be the memory settings.

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

Step 2 of 2:

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?

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.

This was first published in September 2007

Related Q&A; from Greg Robidoux

Restoring a SQL Server database with a corrupt data file

Find out how to restore data from a corrupt database.continue reading

Synchronize databases on two separate active servers

Synchronize databases on separate servers without using SANs. Learn options for server failover in SQL Server including log shipping, database ...continue reading

Restore SQL Server 2000 backups in SQL Server 2005

Restore backups in SQL Server 2000 and SQL Server 2005 with this command.continue reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SQL Server experts

View all SQL Server questions and answers

SearchBusinessAnalytics

BI self-service tools need middle ground on use, governance

Deployments of self-service BI and data discovery tools need to be governed to keep things in order. But finding the right ...

Report highlights growing role for location-mapping software

A new report from Dresner Advisory Services says businesses see increased value in location intelligence software, but products ...

Data science jobs easy to find, tough to fill

Data scientist ranks as the top job in America this year, as low supply and high demand mean big money for those who qualify for ...

SearchDataManagement

New data preparation tools open up more info to analysts

Consultant David Loshin says self-service data preparation software helps give data analysts broader access to business ...

Data quality metrics a governance must, managers say

Data governance managers who spoke during an online conference said that tracking business-oriented metrics on data quality ...

Co-creator Cutting assesses Hadoop future, present and past

In a Q&A; as Hadoop reaches one 10-year milestone in its development, co-creator Doug Cutting talks about the adoption of the big ...

SearchAWS

Amazon EFS stuck in beta, lacks native Windows support

Amazon's long-awaited Elastic File System is expected to hit the market soon, but it won't natively support Windows or ...

New AWS SSL certificate tool explained

AWS Certificate Manager solves some problems companies experienced with traditional SSL certificate services like GoDaddy and ...

Navigate through AWS regions and availability zones

Looking for basics on AWS regions and availability zones -- and how that translates into uptime and availability for cloud ...

SearchOracle

How to use services to balance Oracle RAC database workloads

Database administrators can use Oracle's services mechanism to improve application performance and better manage clustered Oracle...

School district rethinks EBS after Oracle extended support ends

Douglas County School District couldn't change its Oracle extended support contract to cover only what it planned to use. It ...

Newest Oracle Critical Patch Update contains 248 fixes

The January 2016 Critical Patch Update has 248 security fixes, a record-breaking high number. It includes fixes for Oracle ...

SearchContentManagement

SharePoint Managed Metadata Service creates efficiencies

Manually applying metadata to SharePoint deployments is time-consuming and can create inefficiencies. The overlooked Managed ...

Steps to make hybrid SharePoint search work

Since the advent of cloud-based SharePoint, the refrain has been, "Why doesn't search work?" Today, you can configure SharePoint ...

Tips to align SharePoint hybrid licenses and subscriptions

If you’re considering a hybrid SharePoint license, the key is alignment between your cloud and on-premises licensing schemas.

SearchWindowsServer

Windows containers a reality through Hyper-V nested virtualization

Microsoft ushers in the use of containers by developing nested virtualization on the Windows Server 2016 platform.

Windows Server 2016 licensing tweak could cause big headaches

Get ready to pay more, experts warn, when Windows Server licensing fees shift from per-processor to per-core starting with ...

How to stick to your IT security plan

Completing an IT security plan to protect the Windows Server environment requires setting deadlines to stay accountable.

Dig Deeper on Microsoft SQL Server 2005

Related Q&A; from Greg Robidoux

Have a question for an expert?

0 comments

E-Mail

Username / Password

Password

Forgot Password?

Your password has been sent to: