Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

Home > Success Center > Network Configuration Manager (NCM) > Error while executing script - There is insufficient system memory in resource poll 'Internal' to run this query

Error while executing script - There is insufficient system memory in resource poll 'Internal' to run this query

Updated November 4, 2016

Overview

The following error appears when trying to run Configuration Wizard and it appears to be memory issues on your SQL server:

Database configuration failed:

Error while executing script - There is insufficient system memory in resource pool 'internal' to run this query.

Environment

  • All NPM versions
  • All Core versions
  • All SAM versions
  • Window SQL Server 2008 R2

Cause 

This issue is related to MS SQL Server 2008 R2

  • There is a bug in the code that is used to evaluate how many rowsets are required to perform a sorting operation. Therefore, the code greatly overestimates the numbers of rowsets. The required grant estimate in full-text is 64 pages for each rowset that is required to sort.
  • There is a large request that blocks the system from using the memory that is reserved for the full-text query.

Please See the Following Microsoft KB for more information

Resolution

Install SQL Server 2008 R2 Cumulative Update 14

 

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.

 

Last modified
16:57, 3 Nov 2016

Tags

Classifications

Public