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.
 
35.71%
5
I only enable it on some of my instances, i.e. the ones showing tempdb contention issues.
 
64.29%
9
Member Votes: 13, 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: Yesterday @ 11:45 PM
Points: 7,094, Visits: 12,582
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 1:28 AM
Points: 2,105, Visits: 5,393
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 @ 1:36 AM
Points: 42,488, Visits: 35,556
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: Monday, July 28, 2014 6:49 PM
Points: 87, Visits: 545
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