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

  • Question

  • Hello

    I'm accesing a Microsoft SQL Server 2008 R2, SP1,2,3 and 4 are installed and the client server is unusaly slow.

    At top hour we are receiving the error "There is insufficient system memory in resource pool 'internal' to run this query" at the most simple queries. 

    Example: running the query "SELECT id AS ret FROM ORG_UNITS WHERE code = '...';" will give this error when the table has only 40 records.

    Is there a software solution at the SQL server level? We read this article but it didn't help, we have all service packs installed.

    Thank you.


    Tuesday, June 9, 2020 5:23 PM

Answers

  • Hi Victorqedu123,

    >>I'm accesing a Microsoft SQL Server 2008 R2, SP1,2,3 and 4 are installed

    SP3 is the latest SP for SQL server 2008 R2, CU4 is the Cumulative update package  for SQL Server 2008 R2 SP2, CU4 is based on SP2. You need to install the SP3 for SQL server 2008 R2 and apply the latest security update for SQL Server 2008 R2 SP3. Please refer to SQL Server Versions and Build Numbers

    Extended support for SQL Server 2008 and SQL 2008 R2 ended on July 9, 2019. Microsoft will no longer release security updates for any version of SQL Server 2008 and SQL 2008 R2. Don't let your infrastructure and applications go unprotected. We recommend you upgrade your SQL server to a newer version. Please refer to MS document End of support for SQL Server 2008 and SQL Server 2008 R2.

    >>the error "There is insufficient system memory in resource pool 'internal' to run this query"

    According to MS blog, this is a problem in the Microsoft products SQL 2008 R2, if you installed SP3 and the latest security update did not resolve the issue, please try the suggestion from this blog.

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by Victorqedu123 Wednesday, June 10, 2020 2:57 AM
    • Unmarked as answer by Victorqedu123 Wednesday, June 10, 2020 3:17 AM
    • Marked as answer by Victorqedu123 Wednesday, June 10, 2020 3:18 AM
    Wednesday, June 10, 2020 1:57 AM