How to Fix the "There is Insufficient System Memory in Resource Pool 'internal' to Run This Query" Error.
Issue
When trying to use a module on your website, you receive the error:
There is insufficient system memory in resource pool 'internal' to run this query.
Cause
The database command that you are attempting to run is inefficient and requires extensive system resources.
Resolution 1
You should update your query to be more efficient.
Resolution 2
You should add more RAM to your server. Contact our Sales department to discuss adding more RAM to your server.
Workaround
You should adjust your SQL Server's Minimum Memory setting to 500MB or more. While this may cause the module to work correctly, this may slow down the overall performance of your site as well.
Article ID: 150, Created: April 6, 2012 at 9:32 AM, Modified: August 25, 2014 at 2:39 PM