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?
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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