SQL Server Trace Flags - Complete list

  • webrunner

    One Orange Chip

    Points: 29951

    Thanks for this impressively comprehensive list!

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and says Can I join you?
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • przemyslawkus

    Grasshopper

    Points: 12

    One more TF from Microsoft support (SQL Server 2012):

    833 - disables superlatch

    Needs SQL Services restart.

    • This reply was modified 2 months, 1 week ago by  przemyslawkus.
  • kast218

    SSCertifiable

    Points: 6286

    Hi, przemyslawkus. Thanks for this trace flag. Could you provide some extra information.

    What is scope for this flag: session, global, query?

    What is versions (except 2012) SQL Server it works?

  • Jeff Moden

    SSC Guru

    Points: 994921

    Alan Burstein wrote:

    This article is awesome! Thanks for putting it together.

    Alan, the migration to the "improved" SSC website has broken all of the links in your signature line.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • Jeff Moden

    SSC Guru

    Points: 994921

    przemyslawkus wrote:

    One more TF from Microsoft support (SQL Server 2012):

    833 - disables superlatch

    Needs SQL Services restart.

    My recommendation would be not to use those types of trace flags.  Instead, fix the code that's causing a problem because queries on larger data (and it's forever getting larger) may be adversely affected.  Trace Flags are generally not meant to be a panacea of performance (there are exceptions but they are rare).

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • przemyslawkus

    Grasshopper

    Points: 12

    @kast218, Scope: global. I don't know the versions of SQL Server unfortunately...

    @jeff Moden: I don't say this is good to use, I am just sharing what was recommended by MS support as a workaround for a bug.

  • kast218

    SSCertifiable

    Points: 6286

    przemyslawkus wrote:

    One more TF from Microsoft support (SQL Server 2012):

    833 - disables superlatch

    Needs SQL Services restart.

    Added, great thanks for new undocumented flag  (just 2 flags left for 600).

    https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md#833

Viewing 7 posts - 31 through 37 (of 37 total)

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