ronascentes · October 4, 2016 17:42
diff --git a/enable_trace_flags.sql b/enable_trace_flags.sql
 -- Trace flag 1118 turns off mixed page allocations. Preventing mixed page allocations reduces the risk of page latch contention 
 -- on the SGAM allocation bitmatps that track mixed extents; which Paul says is one of the leading causes for contention in tempdb.
 -- When doing allocations for user tables always allocate full extents.  Reducing contention of mixed extent allocations
 DBCC TRACEON (1118,-1)

 -- simply stops SQL Server from writing backup successful messages to the error log.
 DBCC TRACEON (3226,-1)

 -- Changes to automatic update statistics
 DBCC TRACEON (2371,-1)

 -- When growing a data file grow all files at the same time so they remain the same size, reducing allocation contention points.
 --  applies to the entire SQL Server instance, not just to one DB and it affects all files in the same filegroup in a database
 DBCC TRACEON (1117,-1)
	-- Trace flag 1118 turns off mixed page allocations. Preventing mixed page allocations reduces the risk of page latch contention
	-- on the SGAM allocation bitmatps that track mixed extents; which Paul says is one of the leading causes for contention in tempdb.
	-- When doing allocations for user tables always allocate full extents. Reducing contention of mixed extent allocations
	DBCC TRACEON (1118,-1)

	-- simply stops SQL Server from writing backup successful messages to the error log.
	DBCC TRACEON (3226,-1)

	-- Changes to automatic update statistics
	DBCC TRACEON (2371,-1)

	-- When growing a data file grow all files at the same time so they remain the same size, reducing allocation contention points.
	-- applies to the entire SQL Server instance, not just to one DB and it affects all files in the same filegroup in a database
	DBCC TRACEON (1117,-1)