SQL Server: Error 701 There is insufficient system memory to run this query

Error 701: “There is insufficient system memory to run this query” this is a common error for those SQL Server DBA who are managing big size of SQL Server.
When your SQL Server database occupied by lots connections and require more memory to serve this request, sometimes you get Error 701.

There are different alternative to solve this problem.

First, Check your SQL Server setting for “min server memory” and “max server memory”. If you found very small difference in both the value, increase your “max server memory”.

Second, Found out long running queries with its memory usage information and if this query in idle states, please verify and kill this process. The database performance optimization is a major thing for memory usages.

Third, Found out index usages for long running queries because without proper indexing your system DISK I/O increase and its directly affect to your memory.

Fourth, Check the size of the Virtual memory paging file and increase the size of this file.

Fifth, Check the size of the “min memory per query” actually it is by default 1024 KB but in rare situations you can decrease the size of this parameter. Actually, this is not advisable, but you can try it.

Sixth, Try to execute this DBCC command and again this is not advisable because it may affect to the overall performance of the server. But you can try this.

Anvesh Patel

Leave a Reply

2 Comments on "SQL Server: Error 701 There is insufficient system memory to run this query"

Notify of
avatar
Sort by:   newest | oldest | most voted
puur
Guest

Really fascinating read,thank you for publishing it.Was looking for such an info all over the place,but could hardly find it anywhere,but i am blessed that we found your web site.

bonney
Guest

Hello there, just became alert to your blog through Google, and found that it’s
truly informative. I am gonna watch out ffor brussels.
I’ll be grateful if you continue this in future.
Many people will be benefited from your writing. Cheers!

wpDiscuz