CODEWITHSUNDEEP
sql-serversql-server-2008
Joseph
Joseph

Reputation: 473

"Insufficient System Memory" Error in SQL Server 2008

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.

Upvotes: 3

Views: 2947

Answers (4)

gbn
gbn

Reputation: 432667

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

At least two SO questions: One and Two

These may offer something

Upvotes: 1

baldy
baldy

Reputation: 5541

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

Upvotes: 0

user280695
user280695

Reputation: 1

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.

Upvotes: 0

Nick Kavadias
Nick Kavadias

Reputation: 7358

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

Upvotes: 0

Related Questions