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

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

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

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.
Ursache

Microsoft Defect
Lösung

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 übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Titel