Subscribe

SQLServer-DBA.com Links

Subscribe to newsletter

Dba_db2_button

Powered by TypePad
Troubleshoot Error 701 - There is insufficient system memory to run this query

22 July,2013 by Jack Vamvas

Question: How do I troubleshoot a “701 - There is insufficient system memory to run this query” error message?

Answer: According to the SQL Server Books Online “There is insufficient system memory in resource pool '%ls' to run this query.”

If you want to read a problem scenario  check  Error 701 - There is insufficient system memory to run this query    and    SQL Server - Error 701 - There is insufficient system memory

99% of the times I’ve seen this error , the cause is not the current transaction. Although it could be the current transaction which caused the failed memory allocation.

Diagnostic queries usually won’t run when this error message appears.

This troubleshooting list is not exhaustive- but it’s  a priority list I use

1)     Check other services on the server. How much memory are they consuming? It isn’t unusual with external programs such as monitoring agents and AntiVirus programs to consume large amounts of memory

2)     SQL Server memory configurations – Check SQL Server Maximum memory  . Commit some time to workload analysis to calculate an accurate memory requirement for the SQL Server Instance

3)     Troubleshoot memory pressure with Default Trace and Server Memory Change event class

4)     Sys.dm_os_memory_clerks and AWE memory allocation


Author: Jack Vamvas (http://www.sqlserver-dba.com)

******** *******

Subscribe to SQLServer-DBA.com

Latest posts delivered to you daily

Delivered by FeedBurner

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer