"Insufficient System Memory" Error in SQL Server 2008

Question

I get the following error in SQL Server 2008:

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

I recently migrated from SQL Server 2000 to SQL Server 2008, and the system is Windows Server 2K8.

Answer 1

Try using the -g switch as described in this MS KB article to increase the amount of virtual memory reserved for sql server.

Answer 2

The are a -G parameter at sqlserver comfiguration to increse the memtoleave portion memory, reponsable area to execute queries, backups, openqueries, etc. By default, the inital value is 256mb. I suggest increase by 128Mb, but take care about that value. Try to serialize simultaneous executions.

Answer 3

You need to take a serious look at your queries. This could happen if you're doing and 'IN'/'NOT IN' compare on a large string value passed into a query. Rather do it on a lookup table/temp table

Answer 4

There are 2 connect bugs reported: One and Two

At least two SO questions: One and Two

These may offer something