Environment
- CB Protection Server: All Supported
- Microsoft SQL Server: All Supported
Symptoms
Database upgrade fails due to query cost exceeding threshold.
Cause
The database has the query governor enabled in the server connections options page.
Resolution
- Open SQL Management Studio.
- Right click on the SQL Server at the top of the explorer window and select "Properties".
- Select the "Connections" tab.
- Make one of the following changes to help address the issue:
- Uncheck the box for "Use query governor to prevent long-running queries.
- Increase the query governor threshold to a higher threshold.
Additional Notes
Setting the threshold of the query governor to zero will disable the governor, similar to un-checking the box.
Related Content