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

SmartPlant Foundation and Web Client Modified and Retired Functionality

Language
English (United States)
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, you should contact customer support for assistance, but you can also 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’;

Contact customer support for best practices for improving performance on SQL Server.