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

Converse agora com nosso suporte

Voltar

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Título

Error: "There is insufficient system memory in resource pool" in SQL Server 2008 affecting VDI
Descrição

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
Resolução

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 enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Conteúdo recomendado

Título