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?
rwheeler23Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
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
 
LowfatspreadConnect With a Mentor Commented:
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
 
aponcealbuerneConnect With a Mentor Commented:
Hi,

did you see this link?

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

Hope helps
0
All Courses

From novice to tech pro — start learning today.