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?