Click here to Skip to main content
15,397,828 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
The system RAM is 4GB Got the error "There is insufficient system memory in resource pool 'internal' to run this query" while the crystal report is printing more than 200 bills. minimum memory per query(in KB) is 1024. SQL Server 2008-r2 version has been installed.

how can I fix this issue?
if I clear the memory how can I clear it without affecting the current system


What I have tried:

I increased
minimum memory per query(in KB) is to 2048
Posted
Updated 22-May-22 22:31pm
Comments
Richard Deeming 25-May-22 5:25am
   
NB: SQL Server 2008 R2 has been "end-of-life" since September 2019. When the server this is running on eventually dies, you should look to upgrade to a supported version of SQL Server - especially since you can't install that version on any OS later than Windows Server 2012 R2 or Windows 8.1, both of which are effectively "dead". (Server 2012 R2 is eol in October 2023; 8.1 is eol in January 2023.)

Until you replace it, I hope this server is behind some serious firewalls, and has a decent antivirus system in place!

You might try the Cumulative Update 4 for SQL Server 2008 R2 if you don't have that installed already:
KB982854 - FIX: Error "There is insufficient system memory in resource pool 'internal' to run this query" in Microsoft SQL Server[^]
   
Wow. I'm not surprised you are running into this issue. The message you are getting is a SQL Server message and it's really telling you that you don't have enough memory to process your query. If you have a lot of records to work through, you should add a lot more memory.

SQL Server is a server based system meaning that it should be running on a server; which would have a lot more memory than you would get in a desktop system.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900