There is insufficient system memory in resource pool ‘internal’ to run this query.

There is insufficient system memory in resource pool ‘internal’ to run this query.

There is insufficient system memory in resource pool ‘internal’ to run this query.

This article discusses how you can resolve the error message: There is insufficient system memory in resource pool ‘internal’ to run this query. Even though you might get the above error message for different occasions, one thing is for sure (after all, the message is quite self-explanatory), it has to do with memory management. 🙂

Why you got the Insufficient System Memory Error

SQL Server allows you to limit the maximum memory that can be utilized by its Database Engine. You can use this feature in order to allow the OS to have access to memory that cannot be used by SQL Server and thus ensure stability. However you have to remember to re-evaluate this setting in the event of a memory upgrade on the machine.

You can perform the above action as follows:

Right click on instance name in SSMS – Select “Properties” – Select the “Memory” tab. You then get the below dialog (in this example I have set as maximum server memory 3GB):

There is insufficient system memory in resource pool 'internal' to run this query. - Article on SQLNetHub

The above method is a way to ensure OS stability by not allowing SQL Server to consume all memory in any case and by leaving an amount of memory available for the OS.

How to Resolve the Issue

Now, in the case you get the “There is insufficient system memory in resource pool ‘internal’ to run this query.” error you can try the following actions:

Action 1

Run the T-SQL command:

ALTER RESOURCE GOVERNOR RESET STATISTICS;
GO

 

As described on an MSDN Library article, the above command will cause Resource Governor to resets statistics on all workload groups and resource pools including the “internal” resource pool.

 

Action 2

If the above action does not solve the issue you can try to free-up more memory and eventually upgrade the memory capacity of the machine.

 

Other SQL Server troubleshooting articles to check on SQLNetHub:

 

Subscribe to our newsletter and stay up to date!

Check out our latest software releases!

Check out Artemakis’s eBooks!

 

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (5 votes, average: 5.00 out of 5)

Loading...

Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub

There is insufficient system memory in resource pool 'internal' to run this query. Click to Tweet
Artemakis Artemiou
Artemakis Artemiou is a Senior SQL Server and Software Architect, Author, and a 9 Times Microsoft Data Platform MVP (2009-2018). He has over 15 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and TechHowTos.com. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Artemakis's official website can be found at aartemiou.com.