Optimize a SQL Server database - HxGN SDx - Update 63 - Installation & Upgrade

Installation and Setup for HxGN SDx Application Server

Language
English
Product
HxGN SDx
Search by Category
Installation & Upgrade
SmartPlant Foundation / SDx Version
10

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 HxGN SDx database as a memory optimized table and instead use #mem_tmp setting. For more information, see Configure HxGN SDx to use SQL Server #TMP files.