There is insufficient system memory in resource pool 'internal' to run this query.”

We recently started to see this message appear on our 64 bit SQL Server 2008 instance.

There is insufficient system memory in resource pool 'internal' to run this query.”

The only fix is a reboot. The server has 4GB RAM. Should I start playing around with the memory settings for SQL or is there a service pack or hot fix that addresses this issue?
LVL 1
rwheeler23Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LowfatspreadCommented:
how much page file space do you allow the server to have?

how many applications do you have open at the time?

what sort of applications are you running?

what  queries are running when the problem occurs?

How big are your databases/tables?

what else is running on the server?
  is it a dedicated Database server?

what OS (and Fixpacks)
which version of SQL server & fixpacks
0
rwheeler23Author Commented:
How much page file space do they allow the server to have? 4GB – system managed

How many applications do you they open at the time? Other than Symantec AV there are no apps running on the server

What sort of applications are they running? Just SQL

What  queries are running when the problem occurs? I’m not sure- they were training some users on the application, so I imagine it was querying data

How big are the databases/tables? 8GB database file

What else is running on the server?
  Is it a dedicated Database server? Yes

What OS (and Fixpacks) Window Server 2008 R2 with updates from a few weeks ago. SQL Server 2008 with SP1. I’m downloading cumulative update 7 right now and was planning on installing it
Which version of SQL server & fixpacks
0
aponcealbuerneCommented:
Hi,

did you see this link?

http://support.microsoft.com/KB/918483/EN-US

Hope helps
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Surely a memory related issue..
Set Min and Max Server memory in SQL Server to 2000 and 3000 MB's respectively.
Check whether tempdb is set to limited growth or not..
If set to Limited, then change it to Autogrowth with Initial size as 1 GB or 1000 MB and try restarting SQL Server once which should help..

One another option would be to tune the query which gives out this error as it requires lots of resources / carinality or cost.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.