vote up 2 vote down star
1

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.

flag
50% accept rate
service pack version, 32 bit or 64 bit? – Mitch Wheat Feb 3 at 13:34
can you post the DBCC MEMORYSTATUS dump information from your error log. – Mitch Wheat Feb 3 at 13:35
Also, how much memory on the machine, if 32-bit have you enabled /3GB and/or /PAE, how much memory have you allocated to SQL Server, and have you configured the resource governor in any way? – Aaron Bertrand Feb 3 at 14:31
we have 4 GB total memory and we enabled 2.5 gb for SQL server .We disabled Resource governer – Joseph Feb 4 at 6:50
@Joseph: perhaps have a look at some of the answers – gbn 56 mins ago

4 Answers

vote up 0 vote down

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

link|flag
vote up 0 vote down

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.

link|flag
vote up 0 vote down

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

link|flag
vote up 0 vote down

There are 2 connect bugs reported: One and Two

At least to SO questions: One and Two

These may offer something

link|flag

Your Answer

Get an OpenID
or
never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.