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.