"Insufficient System Memory" Error in SQL Server 2008

I get the following error in SQL Server 2008:

There is insuffic开发者_运维问答ient 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.

---

There are 2 connect bugs reported: One (archive) and Two (archive)

At least two SO questions: One and Two

These may offer something

---

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

---

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.

---

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