Configure HxGN SDx to use SQL Server #TMP files - HxGN SDx - Update 31 - Installation & Upgrade

Installation and Setup for HxGN SDx Application Server

Language
English (United States)
Product
HxGN SDx
Search by Category
Installation & Upgrade
SmartPlant Foundation / SDx Version
10
  1. Edit the file SPFAppServer.config, located in <installation_directory>\SPFConfigService\SPFSharedSettings.

  2. Add the following to the <appSettings> section of the file:

    <add key="UseGeneratedTempTableAlways" value="True" />

    You might need to do an IISreset if your server is already running.

  3. To use memory-optimized tempdb metadata, available in Enterprise Edition from SQL Server 2019, type:

    ALTER SERVER CONFIGURATION SET MEMORY_OPTIMIZED TEMPDB_METADATA=ON;

    For more information on the tempdb system database, see tempdb database.

  4. Restart the SQL Server instance.

SHARED Tip To check the status of your change, type:

SELECT SERVERPROPERTY('IsTempdbMetadataMemoryOptimized');