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

Chatee ahora con Soporte

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

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

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

Microsoft Defect
Resolución

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

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Historial del artículo:: Creado el: 9/27/2010
Última actualización: 5/7/2023

Título