-
Edit the file SPFAppServer.config, located in <installation_directory>\SPFConfigService\SPFSharedSettings.
-
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.
-
To use memory-optimized tempdb metadata, available in Enterprise Edition from SQL Server, type:
ALTER SERVER CONFIGURATION SET MEMORY_OPTIMIZED TEMPDB_METADATA=ON;
For more information on the tempdb system database, see tempdb database.
-
Restart the SQL Server instance.
To check the status of your change, type:
SELECT SERVERPROPERTY('IsTempdbMetadataMemoryOptimized');