Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Trace Flag 1118 Expand / Collapse
Do you enable Trace Flag 1118?
Poll ResultsVotes
Yes, I enable it by default on all my instances.
No, I do not like enabling TF 1118 on any of my instances.
I only enable it on some of my instances, i.e. the ones showing tempdb contention issues.
Member Votes: 13, Anonymous Votes: 0. You don't have permission to vote within this poll.
Posted Sunday, January 20, 2013 8:04 AM



Group: General Forum Members
Last Login: Friday, December 2, 2016 3:25 AM
Points: 7,933, Visits: 14,355
Please 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.

There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1409277
Posted Sunday, January 20, 2013 8:12 AM


Group: General Forum Members
Last Login: Today @ 7:13 AM
Points: 2,199, Visits: 6,042
This 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.


To know how to ask questions and increase the chances of getting asnwers:

For better answers on performance questions, click on the following...
Post #1409279
Posted Sunday, January 20, 2013 11:17 AM



Group: General Forum Members
Last Login: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
I'll only use it if I have TempDB contention and splitting the files doesn't help. Haven't needed it since SQL 2000.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1409293
Posted Tuesday, January 22, 2013 3:01 PM


Group: General Forum Members
Last Login: Thursday, September 1, 2016 7:38 AM
Points: 102, Visits: 766
I found this article in which the author ran a test with 1 TempDB file. No performance gains were made.

Also found this presentation on Trace Flags, contains section on Production Trace Flags, 1118 being one of them. References white paper.
Post #1410273
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse