InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 02:27:40 GMT20http://www.sqlservercentral.com/Forums/Topic1409277-1550-1.aspxI found [url=http://sqlblog.com/blogs/linchi_shea/archive/2009/10/02/sql-server-challenge-show-me-trace-flag-1118-is-significant-a-quick-update.aspx]this article [/url]in which the author ran a test with 1 TempDB file. No performance gains were made.Also found [url=http://www.google.com/url?sa=t&rct=j&q=&esrc=s&frm=1&source=web&cd=5&cad=rja&ved=0CFMQFjAE&url=http%3A%2F%2Fvictorisakov.files.wordpress.com%2F2011%2F10%2Fsql_pass_summit_2011-important_trace_flags_that_every_dba_should_know-victor_isakov.pdf&ei=tQr_UIiOAsil2AW8_YGwAg&usg=AFQjCNEihTHQ2cd0LZ4m_pUNmnPz3WZQSQ&sig2=cnoL046kp8TDNsDz9xj03w]this presentation [/url]on Trace Flags, contains section on Production Trace Flags, 1118 being one of them. References white paper.Tue, 22 Jan 2013 15:01:36 GMTalanspeckmanhttp://www.sqlservercentral.com/Forums/Topic1409277-1550-1.aspxI'll only use it if I have TempDB contention and splitting the files doesn't help. Haven't needed it since SQL 2000.Sun, 20 Jan 2013 11:17:05 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1409277-1550-1.aspxThis trace flag helped me when I was working with SQL Server 2000 about 8 years ago. Since I've stopped working with SQL Server 2000, I did not have to use it.AdiSun, 20 Jan 2013 08:12:53 GMTAdi Cohn-120898http://www.sqlservercentral.com/Forums/Topic1409277-1550-1.aspxPlease share what helped shape your point of view on whether or not to enable TF 1118 in your SQL Server 2008 or 2008 R2 instances.Sun, 20 Jan 2013 08:04:53 GMTopc.three