Frank van Puffelen
Reputation: 598728
What causes this error: "There is insufficient system memory in resource pool 'internal' to run this query"?
I occasionally get this error message on a Tridion 2011 SP1 development machine:
There is insufficient system memory in resource pool 'internal' to run this query. Unable to save Schema (tcm:0-0-0). A database error occurred while executing Stored Procedure "EDA_ORG_ITEMS_FINDUNIQUENESSCONFLICTS".EDA_ORG_ITEMS_FINDUNIQUENESSCONFLICTS
Searching for the error message here on StackOverflow suggests rewriting the stored procedure to not use temporary tables. Without doing that, does anyone know how to get rid of this error message?
Upvotes: 2
Views: 2453
Answers (1)
Frank van Puffelen
Reputation: 598728
Although it is hard to be certain that the upgrade fixed it, the problem hasn't occurred anymore after upgrading SQL Server 2008 R2 to SP1.
Upvotes: 3
Related Questions
- There is insufficient system memory in resource pool 'default' to run this query
- There is insufficient system memory in resource pool 'default' to run this query. on sql
- "There is insufficient system memory in resource pool 'default' to run this query" during execution of stored procedure
- Insufficient system memory in resource pool to execute SQL Scripts in SQL Server 2008
- Generating an Entity Framework model - There is insufficient system memory in resource pool 'internal' to run this query
- ERROR: Insufficient system memory in resource pool 'internal' to run this query. EF + Visual Studio 2012
- The query processor ran out of internal resources exception
- There is insufficient system memory in resource pool 'internal' to run this query
- What can cause InvalidOperationException: max pool size reached except for the obvious
- sql server 2005 sp3 insufficient memory to run query problem