Generic Solution:
Check the settings for both min server memory (MB) and max server memory (MB). If max server memory (MB) is a value close to the value of min server memory (MB), then increase the max server memory (MB) value.
Check the size of the virtual memory paging file. If possible, increase the size of the file.
For SQL Server 2005:
Install following HotFix and Restart Server.
Additionally following DBCC Commands can be ran to free memory:
- DBCC FREESYSTEMCACHE
- DBCC FREESESSIONCACHE
- DBCC FREEPROCCACHE
Reference : Pinal Dave (https://blog.sqlauthority.com)
24 Comments. Leave new
Hi Pinal i am one of the regular follower of you, i have one doubt could you please let me know the exact resolution.Error as follows “” DBD :: ODBC :: st execute failed :[microsoft] [odbc sqlserver driver][sqlserver] there is insufficient system memory in resource pool ‘default’ to run this query.(SQL-42000)(DBD :st_execute/sqlexecute err =-1) at err_function_lib.pl line 765 “
Hi Pinal. I am getting the same issue
There is insufficient system memory in resource pool ‘default’ to run this query.
Error: 701 Severity: 17 State: 65.
using windows 2003 32 bit ,sqlserver 2008 r2
Error message when you try to run several queries on large data sets at the same time in SQL Server 2008 R2: “701 There is insufficient system memory to run this query”
Is there any fix available for this error?