How to Fix the "There is Insufficient System Memory in Resource Pool 'internal' to Run This Query" Error.
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.
The database command that you are attempting to run is inefficient and requires extensive system resources.
You should update your query to be more efficient.
You should add more RAM to your server. Contact our Sales department to discuss adding more RAM to your server.
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.