Changing compatibility level to improve variable performance from SQL Server 2016 (retired) - SmartPlant Foundation - SmartPlant Foundation 2020 - Help - Hexagon

SmartPlant Foundation and Web Client Modified and Retired Functionality

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)

From Update 31, SmartPlant Foundation no longer supports SQL Server 2016.

SQL Server 2016 has been observed to sometimes use alternative execution plans that can cause performance to vary (degrade, then improve, then degrade again, and so on). If you are seeing variations in performance, try running your installation in SQL Server 2008 compatibility mode.

To run in SQL Server compatibility mode, execute this statement, substituting your database name for DBNAME.

ALTER DATABASE DBNAME SET COMPATIBILITY_LEVEL = 100;

After the compatibility level is changed, you can confirm it by executing the following query:

SELECT name, compatibility_level FROM sys.databases where name=’DBNAME’;