Post reply

Does T1118 flag applies to all databases in the sql in instance or only to TempDB [SQL Server 2008 R2]?

  • November 19, 2015 at 8:08 am

    #322794

    Hello Experts

    Please suggest whether applying T1118 flag applies to all databases in the sql in instance or only to TempDB [SQL Server 2008 R2]?

    Thanks.

  • November 19, 2015 at 8:09 am

    #1841013

    IIRC, it applies to all databases

    Edit, yep MSDN details 1118 is a global traceflag so applies to all DB's

  • November 19, 2015 at 9:22 am

    #1841049

    Yes it does apply to all the databases on that instance, you will see most benefit for tempdb. Kendra has explained more in detail here [/url]

  • November 19, 2015 at 9:25 am

    #1841050

    So if that gives most benefit to tempdb, whether there is any symptom of high tempdb usage, can we go ahead and apply that? I was wondering that trace flags are required to enable to deal with a specific syndrome/issue. Once its fixed or identified then it must be turned off.

    Please shed more light on this

    Thanks.

  • November 19, 2015 at 9:36 am

    #1841053

    Something you probably don't want to hear,"it depends" . I would start reading some tempdb related myths from sqlskills.com and go from there. Enabling T1118 should be safe, actually starting from SQL 2016 it is enabled by default and there are multiple tempdb files by default. Now would it solve your tempdb issue? I don't know. As always test it. Good luck 🙂

  • November 19, 2015 at 9:39 am

    #1841055

    Awesome. It all depends upon case to case. Perhaps, I too don't believe that it is a mandatory flag to enable in all SQL Servers.

    Any further advise by other experts?

    Thanks.

  • November 23, 2015 at 2:47 pm

    #1841869

    The issue is IF you have a DB with multiple data files and all of the data files do not need to be the same size (which is usually the case) and the multiple data files do not need to auto grow by the same amount of space.

    I would have already enabled the trace flag IF it only affected tempdb...

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply