Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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.
0%
0
No, I do not like enabling TF 1118 on any of my instances.
 
30.77%
4
I only enable it on some of my instances, i.e. the ones showing tempdb contention issues.
 
69.23%
9
Member Votes: 12, Anonymous Votes: 0. You don't have permission to vote within this poll.
Author
Message
Posted Sunday, January 20, 2013 8:04 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
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
Posted Sunday, January 20, 2013 8:12 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 5:39 AM
Points: 2,104, Visits: 5,378
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
Posted Sunday, January 20, 2013 11:17 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:52 AM
Points: 41,530, Visits: 34,446
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
Posted Tuesday, January 22, 2013 3:01 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 10:19 AM
Points: 86, Visits: 539
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