SQL Server Trace Flags - Complete list

  • kast218

    SSCertifiable

    Points: 6285

    Comments posted to this topic are about the item SQL Server Trace Flags - Complete list

  • Br. Kenneth Igiri

    SSCarpal Tunnel

    Points: 4471

    Mr. Taranov this is an amazing article. Very very useful.

    Br. Kenneth Igiri
    www.scribblingsage.com
    All nations come to my light, all kings to the brightness of my rising

  • kast218

    SSCertifiable

    Points: 6285

    Br. Kenneth Igiri - Thursday, February 23, 2017 2:19 AM

    Mr. Taranov this is an amazing article. Very very useful.

    Thank you for your feedback! We maintained and updated this list regularly on Github

    If you find some typos, errors, mistakes or some enchantments - please post anywhere: here, email me or (best option create issue on Github or pull request)

  • Henrico Bekker

    One Orange Chip

    Points: 27652

    awesome, added to favorites

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • Jeff Moden

    SSC Guru

    Points: 994523

    VERY useful.  Thank you for taking the time to put it together.

    On TF 8666... the description is a bit unremarkable as to what it can actually be used for.  For example, one of the things that it causes to be included in execution plans are the names of the stats it used to come up with the plan.  Using a bit o' XML magic and over time, it allows you to clearly identify which stats are actually in use so that you can delete unused stats.

    --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)

  • SQL Guy 1

    SSCoach

    Points: 15726

    Excellent! Very useful info. Thanks a lot.

  • kast218

    SSCertifiable

    Points: 6285

    Jeff Moden - Thursday, February 23, 2017 5:45 AM

    VERY useful.  Thank you for taking the time to put it together.

    On TF 8666... the description is a bit unremarkable as to what it can actually be used for.  For example, one of the things that it causes to be included in execution plans are the names of the stats it used to come up with the plan.  Using a bit o' XML magic and over time, it allows you to clearly identify which stats are actually in use so that you can delete unused stats.

    Jeff, great thanks for your answer, added to github. Be free to add pull request or just post a new comment.

  • kast218

    SSCertifiable

    Points: 6285

    SQL Guy 1 - Thursday, February 23, 2017 7:47 AM

    Excellent! Very useful info. Thanks a lot.

    Thanks!

  • Sreekanth B

    SSCertifiable

    Points: 6122

    Fantastic compilation. Thanks Taranov!

  • Jeff Moden

    SSC Guru

    Points: 994523

    kast218 - Thursday, February 23, 2017 9:11 AM

    Jeff Moden - Thursday, February 23, 2017 5:45 AM

    VERY useful.  Thank you for taking the time to put it together.

    On TF 8666... the description is a bit unremarkable as to what it can actually be used for.  For example, one of the things that it causes to be included in execution plans are the names of the stats it used to come up with the plan.  Using a bit o' XML magic and over time, it allows you to clearly identify which stats are actually in use so that you can delete unused stats.

    Jeff, great thanks for your answer, added to github. Be free to add pull request or just post a new comment.

    I cannot take the credit for it.  The man in the following article deserves the credit.  It's a fantastic article if you're having problems with too many stats and need to find what they are.
    https://blogfabiano.com/2012/07/03/statistics-used-in-a-cached-query-plan/

    --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)

  • SQLRNNR

    SSC Guru

    Points: 281210

    Jeff Moden - Thursday, February 23, 2017 5:45 AM

    VERY useful.  Thank you for taking the time to put it together.

    On TF 8666... the description is a bit unremarkable as to what it can actually be used for.  For example, one of the things that it causes to be included in execution plans are the names of the stats it used to come up with the plan.  Using a bit o' XML magic and over time, it allows you to clearly identify which stats are actually in use so that you can delete unused stats.

    very useful information there Jeff.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Jeff Moden

    SSC Guru

    Points: 994523

    SQLRNNR - Friday, February 24, 2017 12:26 PM

    Jeff Moden - Thursday, February 23, 2017 5:45 AM

    VERY useful.  Thank you for taking the time to put it together.

    On TF 8666... the description is a bit unremarkable as to what it can actually be used for.  For example, one of the things that it causes to be included in execution plans are the names of the stats it used to come up with the plan.  Using a bit o' XML magic and over time, it allows you to clearly identify which stats are actually in use so that you can delete unused stats.

    very useful information there Jeff.

    Again, though, I can't take the credit for it.  I learned it on the following link.  I have tested it on my busy server but haven't yet implemented the "capture over time" part of it.  On that busy server and despite the size and huge number of execution plans, it only takes about 10 minutes to execute and does so without much interference..
    https://blogfabiano.com/2012/07/03/statistics-used-in-a-cached-query-plan/

    --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)

  • Ed Wagner

    SSC Guru

    Points: 286957

    That's quite a list - and very useful.  I especially like the links for more information on each one.  Thanks for posting it.

  • kast218

    SSCertifiable

    Points: 6285

    Ed Wagner - Sunday, February 26, 2017 4:44 PM

    That's quite a list - and very useful.  I especially like the links for more information on each one.  Thanks for posting it.

    Thanks for feedback!

  • admin 31599

    SSC-Addicted

    Points: 474

    Link to github seems to be broken.
    But the one you posted in this thread is Ok.

    Thanks!

Viewing 15 posts - 1 through 15 (of 36 total)

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