NPM Upgrade Failed "The query has been cancelled because the estimated cost of this query (318) exceeds the configured threshold of 300. Contact the system administrator."
In upgrading from NPM we encountered the following error at the end of the configuration wizard:
"The query has been cancelled because the estimated cost of this query (xxx) exceeds the configured threshold of 300. Contact the system administrator."
After 3 hours, SW Support could not figure it out, they were trying to run "SET QUERY_GOVERNOR_COST_LIMIT value" but that's a "per-connection" query that would have had to be embedded in the installation's query for it to work.
I found an article from TechNet that showed me a way to change the limit for the entire SQL server:
1. SSMS: In the Server Properties dialog box, go to the Connections page.
2. Select the option Use Query Governor To Prevent Long-Running Queries.
3. In the box below the option, type a maximum query cost limit. The valid range is 0 through 2,147,483,647. A value of 0 disables the query governor; any other value sets a maximum query cost limit.
4. Click OK.
Ran the configuration wizard again and this problem was gone.
The configuration wizard failed again but for a different reason, something to do with SQL permissions of the SQL username used by SolarWinds for re-indexing something or other, SW Support did help with that one.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.
Learn more today by joining now.