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.
Asked
Active
Viewed 2,900 times
3
George Stocker
- 57,289
- 29
- 176
- 237
Joseph
- 473
- 2
- 8
- 17
-
service pack version, 32 bit or 64 bit? – Mitch Wheat Feb 03 '10 at 13:34
-
can you post the DBCC MEMORYSTATUS dump information from your error log. – Mitch Wheat Feb 03 '10 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 03 '10 at 14:31
-
we have 4 GB total memory and we enabled 2.5 gb for SQL server .We disabled Resource governer – Joseph Feb 04 '10 at 06:50
-
perhaps have a look at some of the answers – gbn Mar 28 '10 at 10:15
4 Answers
0
Try using the -g switch as described in this MS KB article to increase the amount of virtual memory reserved for sql server.
Nick Kavadias
- 7,542
- 2
- 37
- 46
0
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.
0
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
baldy
- 5,524
- 4
- 22
- 19