Error: "There is insufficient system memory in resource pool" in SQL Server 2008 affecting VDI (4220717)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error: "There is insufficient system memory in resource pool" in SQL Server 2008 affecting VDI
Description

SQL Server Full-Text Search service can affect the performance of SQL Server (2005 & 2008) when it is indexing text in tables. Indexing large amounts of text uses up server resources, reducing the CPU time and memory that could be used by your users running their SQL Server-based applications.
In SQL Server 2008 an error may display "There is insufficient system memory in resource pool 'internal' to run this query" error message when you run a full-text query that uses compound words in Microsoft SQL Server 2008.
Additionally, if you run a Full-Text query successfully after this problem occurs, you receive the same error message.

Or in the SQL Server Log -- Error: 701, Severity: 17, State: 123. There is insufficient system memory in resource pool 'internal' to run this query.
There may also be VDI memory errors mistaken as LiteSpeed errors.
Cause

Microsoft Defect
Resolution

Cumulative Update 9 for SQL Server 2008 Service Pack 1. For more information about this cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
2083921 (https://support.microsoft.com/en-us/kb/2083921 ) cumulative update 9 for SQL Server 2008 Service Pack 1
-----------------------
https://support.microsoft.com/en-gb/kb/982854

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title