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.
-
service pack version, 32 bit or 64 bit?Mitch Wheat– Mitch Wheat2010-02-03 13:34:18 +00:00Commented Feb 3, 2010 at 13:34
-
can you post the DBCC MEMORYSTATUS dump information from your error log.Mitch Wheat– Mitch Wheat2010-02-03 13:35:18 +00:00Commented Feb 3, 2010 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– Aaron Bertrand2010-02-03 14:31:31 +00:00Commented Feb 3, 2010 at 14:31
-
we have 4 GB total memory and we enabled 2.5 gb for SQL server .We disabled Resource governerJoseph– Joseph2010-02-04 06:50:24 +00:00Commented Feb 4, 2010 at 6:50
-
perhaps have a look at some of the answersgbn– gbn2010-03-28 10:15:34 +00:00Commented Mar 28, 2010 at 10:15
Add a comment
|
4 Answers
Try using the -g switch as described in this MS KB article to increase the amount of virtual memory reserved for sql server.
Comments
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.
Comments
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
