Each configuration has its unique characteristics, so it is important to monitor performance using tools like Query Store. In most cases, system performance and scalability can be improved in a multi-user environment.
We do not recommend creating the GRAPH_TMP table in the SmartPlant Foundation database as a memory optimized table and instead use #mem_tmp setting. For more information,
see Configure SmartPlant Foundation to use SQL Server #TMP files.