Trace Flag 1118

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Trace Flag 1118

Trace Flag 1118

Rate Topic

Display Mode

Topic Options

Do you enable Trace Flag 1118?

Poll Results

Votes

Yes, I enable it by default on all my instances.

No, I do not like enabling TF 1118 on any of my instances.

44.44%

I only enable it on some of my instances, i.e. the ones showing tempdb contention issues.

55.56%

Member Votes: 8, Anonymous Votes: 0. You don't have permission to vote within this poll.

Author

Message

opc.three

Posted Sunday, January 20, 2013 8:04 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 11:33 AM
Points: 6,713, Visits: 11,748

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1409277

Adi Cohn-120898

Posted Sunday, January 20, 2013 8:12 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 9:50 AM
Points: 2,019, Visits: 4,923

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.

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1409279

GilaMonster

Posted Sunday, January 20, 2013 11:17 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 9:46 AM
Points: 37,712, Visits: 29,966

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 2008, MVP
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

alanspeckman

Posted Tuesday, January 22, 2013 3:01 PM

Valued Member

Group: General Forum Members
Last Login: Sunday, May 19, 2013 12:16 PM
Points: 62, Visits: 382

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 »

Permissions