none
There is insufficient system memory in resource pool 'internal' to run this query. RRS feed

  • Question

  • Hello Everyone,

    in sql server error log i found below given error with heavy messages and i am unale to open Activity Monitor.

    error:

    There is insufficient system memory in resource pool 'internal' to run this query.

    enviornment is

    windows server 2008 R2 64 bit,

    sql server 2008 R2 64 bit,

    RAM :16 GB

    processors:24

    As per RAM i assigned Max Server Memory:13107.


    mastanvali shaik

    Thursday, August 28, 2014 2:16 PM

All replies

  • What service pack level you are at? If you aren't at the latest service pack, then apply the latest service pack.

    Refer the list of the bugs that are fixed on SP1.

    http://support.microsoft.com/kb/2528583

    --Prashanth

    Thursday, August 28, 2014 2:36 PM
  • Sounds like you may be using CLR objects, remote OLE connections or something else that uses memory which is not limited by max server memory. You may want to reduce your max server memory to give non buffer pool objects a little more breathing room.

    Sql Server, SSAS & Azure Db Performance Tuning & Monitoring Software | www.minidba.com

    Friday, August 29, 2014 1:44 AM
  • First check up this:

    http://support.microsoft.com/kb/982854

    If patching things won't fix it, I would also check indexes. Sometimes very large joins (or recursive functions) without proper indexes make SQL go coocoo.

    Friday, August 29, 2014 6:17 AM
  • Hi mastanvali,

    Based on my understanding, you came across an issue when you wanted to open Activity Monitor. Then you checked in SQL Server error log and found an error message “There is insufficient system memory in resource pool 'internal' to run this query.”

    Firstly, I would like to know if you have checked event log (Windows Application log). I would appreciate it if you can provide event log and detailed SQL Server error log.

    Besides, I suggest you use DBCC MEMORYSTATUS command to trouble Microsoft SQL Server memory consumption issues. For detail information, please refer to this article: How to use the DBCC MEMORYSTATUS command to monitor memory usage on SQL Server 2005 (http://support.microsoft.com/kb/907877).

    Best regards,
    Qiuyun Yu


    Friday, August 29, 2014 7:58 AM
  • Shaik,

    please post more information about OOM error. We can only guess and provide various support articles which might/might not be applicable to your scenario. You just posted a fragement and went AWOL. Unless you provide more information we cannot help much. So if you still need help please post errorlog when this message came and also dbcc memorystatus output for analysis ,preferably on skydrive


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Articles

    Friday, August 29, 2014 8:42 AM
    Moderator
  • hi ,<o:p></o:p>

    As suggested above, please make sure that you are on latest Service Pack .

    Please find below URL, helps you to understand the causes of this error and resolution steps.<o:p></o:p>

    http://support.microsoft.com/kb/982854 <o:p></o:p>


    Monday, September 1, 2014 5:39 AM