SQL Server 2016 discontinued trace flag 1117 and 1118 for TempDB. Use the options in ALTER DATABASE instead, as I found on a client server.
SQL SERVER – What is Trace Flag – An Introduction
What is a trace flag, how do you turn one on, and how do you keep it after a restart? A beginner’s introduction, including the startup parameter option.
SQL Server 2016 – Introducing AutoGrow and Mixed_Page_Allocations Options – TraceFlags
A reader asked if trace flags 1117 and 1118 work for user databases. SQL Server 2016 turns them into the AutoGrow and Mixed_Page_Allocations options.
SQL SERVER – Identifying Page Types
During a consulting session on SQL Server building blocks, a DBA asked me about pages. Here is how to identify Page Types in your database, back to basics.
SQL SERVER – What are my Trace Flags Enabled on SQL Server?
A DBA friend wanted to see the trace flags enabled on his production servers. Here is how to find them easily, and a word of caution about using them.
mssql-conf: Configuring SQL Server on Linux Without a GUI
Use mssql-conf for SQL Server on Linux memory, file defaults, Agent, ports, and trace flags, then verify effective settings after restart.
Stopping Backup Success Messages From Flooding the Error Log
Reduce backup success messages in the SQL Server error log with trace flag 3226, verify msdb history, and cycle logs safely.