SQL Server Trace Flags - Complete list

  • kast218

    SSCertifiable

    Points: 6286

    admin 31599 - Wednesday, March 1, 2017 10:14 PM

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

    Thanks!

    Great thanks for feedback. I edit article to fix broken link and add some info in thanks to section.

  • steinar.andersen@sqlservice.se

    Valued Member

    Points: 69

    kast218 - Thursday, March 2, 2017 12:46 AM

    admin 31599 - Wednesday, March 1, 2017 10:14 PM

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

    Thanks!

    Great thanks for feedback. I edit article to fix broken link and add some info in thanks to section.

    kast218 - Wednesday, March 1, 2017 8:07 AM

    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!

    It's a nice list, and pretty much a direct ripoff of my blogpost here http://www.sqlservice.se/updated-microsoft-sql-server-trace-flag-list/

  • kast218

    SSCertifiable

    Points: 6286

    steinar.andersen@sqlservice.se - Friday, March 31, 2017 1:59 AM

    kast218 - Thursday, March 2, 2017 12:46 AM

    admin 31599 - Wednesday, March 1, 2017 10:14 PM

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

    Thanks!

    Great thanks for feedback. I edit article to fix broken link and add some info in thanks to section.

    kast218 - Wednesday, March 1, 2017 8:07 AM

    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!

    It's a nice list, and pretty much a direct ripoff of my blogpost here http://www.sqlservice.se/updated-microsoft-sql-server-trace-flag-list/

    Initially, as a basic list, I used the wonderful article Yusuf Anis SQL Server Trace Flags (http://www.sqlservercentral.com/articles/trace+flags/70131/), then I found your post from which I made a single compilation with Yusuf Anis list. But most of the information I picked up in the excellent post Aaron Morelli A Topical Collection of SQL Server Flags (https://sqlcrossjoin.wordpress.com/2013/10/28/a-topical-collection-of-sql-server-flags/). All sources used by me are indicated in the Source Link and Thanks To section: https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md

    For 1.5 years, a huge amount of work was done to refine the 3 lists in a single document: hundreds of typos and broken links have been corrected, new information were added. Starting from 2015-11-02, 30 commits were made on this file, some of them took more than 2 hours of work, and in total time costs amounted to about 50 hours (https://github.com/ktaranov/sqlserver-kit/commits/master/SQL%20Server%20Trace%20Flag.md?after=34839581ca0a9ba5291de3da960bb310a39aaad0+34). Great thanks to Alexander Titenko for awesome help in this.

    Yes, your list has also been used and this fact is reflected in the thank you section and in the recommended links. But do simple arithmetic calculations: there are only 176 flags in your list, 511 in github list! If you think that I violated your intellectual property rights in any way, you can get an issue on Github (https://github.com/ktaranov/sqlserver-kit/issues).

    I didn't try to reduce your contribution to the creation of the final list - your post is very good, but I'm very sorry for the colossal work (which I also put in public under the MIT license, i.e. anyone can make their version, or Improve existing) I get accused of stealing and plagiarism.

  • steinar.andersen@sqlservice.se

    Valued Member

    Points: 69

    kast218 - Friday, March 31, 2017 2:38 AM

    steinar.andersen@sqlservice.se - Friday, March 31, 2017 1:59 AM

    kast218 - Thursday, March 2, 2017 12:46 AM

    admin 31599 - Wednesday, March 1, 2017 10:14 PM

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

    Thanks!

    Great thanks for feedback. I edit article to fix broken link and add some info in thanks to section.

    kast218 - Wednesday, March 1, 2017 8:07 AM

    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!

    It's a nice list, and pretty much a direct ripoff of my blogpost here http://www.sqlservice.se/updated-microsoft-sql-server-trace-flag-list/

    Initially, as a basic list, I used the wonderful article Yusuf Anis SQL Server Trace Flags (http://www.sqlservercentral.com/articles/trace+flags/70131/), then I found your post from which I made a single compilation with Yusuf Anis list. But most of the information I picked up in the excellent post Aaron Morelli A Topical Collection of SQL Server Flags (https://sqlcrossjoin.wordpress.com/2013/10/28/a-topical-collection-of-sql-server-flags/). All sources used by me are indicated in the Source Link and Thanks To section: https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md

    For 1.5 years, a huge amount of work was done to refine the 3 lists in a single document: hundreds of typos and broken links have been corrected, new information were added. Starting from 2015-11-02, 30 commits were made on this file, some of them took more than 2 hours of work, and in total time costs amounted to about 50 hours (https://github.com/ktaranov/sqlserver-kit/commits/master/SQL%20Server%20Trace%20Flag.md?after=34839581ca0a9ba5291de3da960bb310a39aaad0+34). Great thanks to Alexander Titenko for awesome help in this.

    Yes, your list has also been used and this fact is reflected in the thank you section and in the recommended links. But do simple arithmetic calculations: there are only 176 flags in your list, 511 in github list! If you think that I violated your intellectual property rights in any way, you can get an issue on Github (https://github.com/ktaranov/sqlserver-kit/issues).

    I didn't try to reduce your contribution to the creation of the final list - your post is very good, but I'm very sorry for the colossal work (which I also put in public under the MIT license, i.e. anyone can make their version, or Improve existing) I get accused of stealing and plagiarism.

    You know what? You are right. I was too fast in judging you. I just found this article, and on the surface it looked just like a copy of mine. But as you say, you have added a lot to the total list, nice job!

  • kast218

    SSCertifiable

    Points: 6286

    steinar.andersen@sqlservice.se - Monday, April 3, 2017 6:23 AM

    kast218 - Friday, March 31, 2017 2:38 AM

    steinar.andersen@sqlservice.se - Friday, March 31, 2017 1:59 AM

    kast218 - Thursday, March 2, 2017 12:46 AM

    admin 31599 - Wednesday, March 1, 2017 10:14 PM

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

    Thanks!

    Great thanks for feedback. I edit article to fix broken link and add some info in thanks to section.

    kast218 - Wednesday, March 1, 2017 8:07 AM

    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!

    It's a nice list, and pretty much a direct ripoff of my blogpost here http://www.sqlservice.se/updated-microsoft-sql-server-trace-flag-list/

    Initially, as a basic list, I used the wonderful article Yusuf Anis SQL Server Trace Flags (http://www.sqlservercentral.com/articles/trace+flags/70131/), then I found your post from which I made a single compilation with Yusuf Anis list. But most of the information I picked up in the excellent post Aaron Morelli A Topical Collection of SQL Server Flags (https://sqlcrossjoin.wordpress.com/2013/10/28/a-topical-collection-of-sql-server-flags/). All sources used by me are indicated in the Source Link and Thanks To section: https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md

    For 1.5 years, a huge amount of work was done to refine the 3 lists in a single document: hundreds of typos and broken links have been corrected, new information were added. Starting from 2015-11-02, 30 commits were made on this file, some of them took more than 2 hours of work, and in total time costs amounted to about 50 hours (https://github.com/ktaranov/sqlserver-kit/commits/master/SQL%20Server%20Trace%20Flag.md?after=34839581ca0a9ba5291de3da960bb310a39aaad0+34). Great thanks to Alexander Titenko for awesome help in this.

    Yes, your list has also been used and this fact is reflected in the thank you section and in the recommended links. But do simple arithmetic calculations: there are only 176 flags in your list, 511 in github list! If you think that I violated your intellectual property rights in any way, you can get an issue on Github (https://github.com/ktaranov/sqlserver-kit/issues).

    I didn't try to reduce your contribution to the creation of the final list - your post is very good, but I'm very sorry for the colossal work (which I also put in public under the MIT license, i.e. anyone can make their version, or Improve existing) I get accused of stealing and plagiarism.

    You know what? You are right. I was too fast in judging you. I just found this article, and on the surface it looked just like a copy of mine. But as you say, you have added a lot to the total list, nice job!

    Thanks for feedback and for your article.

  • SQLRNNR

    SSC Guru

    Points: 281210

    While it is a rather comprehensive list, there are some undocumented Trace Flags missing. Maybe a change in title would be appropriate? 😉

    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

  • kast218

    SSCertifiable

    Points: 6286

    SQLRNNR - Monday, April 3, 2017 12:23 PM

    While it is a rather comprehensive list, there are some undocumented Trace Flags missing. Maybe a change in title would be appropriate? 😉

    I will update title on holidays to: SQL Server Trace Flag List (with new 9939 flag)

    Also, if you find some new flags or typos in this list be free create issue or just post it here.

  • kast218

    SSCertifiable

    Points: 6286

    Add new 7 trace flags - now 518. Update some info and fix broken links, add new links.

  • gladchenko-495957

    SSC Enthusiast

    Points: 162

    ??????, ????? 9806, 9807 ? 9808 ?????????? ????? ?????????? ? ????????? ??????? ????? -? (??????? ????????? ?????? ?????????? ???????? ??????????? ? ???????? ??????????????????).

  • kast218

    SSCertifiable

    Points: 6286

    gladchenko-495957 - Friday, September 15, 2017 5:30 AM

    Похоже, флаги 9806, 9807 и 9808 поÑвлÑÑŽÑ‚ÑÑ Ð¿Ð¾Ñле добавление в параметры запуÑка флага -Ñ… (который выключает многие вÑтроенные ÑредÑтва мониторинга и Ñчётчики производительноÑти).

    ÐлекÑандр, ÑпаÑибо за Ñообщение. Ðе могли бы вы дать ÑÑылку или подробнее опиÑать данные флаги?

  • jobbish

    SSC Journeyman

    Points: 81

    Trace flag 692 is documented here: https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql
    Trace flag 9448 disables the referential integrity operator and is mentioned here: https://orderbyselectnull.com/2017/12/05/the-referential-integrity-operator/

  • kast218

    SSCertifiable

    Points: 6286

    jobbish - Monday, December 4, 2017 10:21 PM

    jobbish thank you very much for this info, updated via https://github.com/ktaranov/sqlserver-kit/commit/d2a1b366123ae249b49a1cbbc58ab480a5492687
    Also update article here, waiting for re-publication.

    Be free post here or github any issue or pull request about traces flags, thanks again.

    Is it your blog https://orderbyselectnull.com/ ?

  • jobbish

    SSC Journeyman

    Points: 81

    kast218 - Tuesday, December 5, 2017 1:31 AM

    jobbish - Monday, December 4, 2017 10:21 PM

    jobbish thank you very much for this info, updated via https://github.com/ktaranov/sqlserver-kit/commit/d2a1b366123ae249b49a1cbbc58ab480a5492687
    Also update article here, waiting for re-publication.

    Be free post here or github any issue or pull request about traces flags, thanks again.

    Is it your blog https://orderbyselectnull.com/ ?

    Yes, that is my blog.

    Thanks for putting together this list and for all of the work you do to maintain it!

  • kast218

    SSCertifiable

    Points: 6286

    jobbish - Tuesday, December 5, 2017 6:47 AM

    kast218 - Tuesday, December 5, 2017 1:31 AM

    jobbish - Monday, December 4, 2017 10:21 PM

    jobbish thank you very much for this info, updated via https://github.com/ktaranov/sqlserver-kit/commit/d2a1b366123ae249b49a1cbbc58ab480a5492687
    Also update article here, waiting for re-publication.

    Be free post here or github any issue or pull request about traces flags, thanks again.

    Is it your blog https://orderbyselectnull.com/ ?

    Yes, that is my blog.

    Thanks for putting together this list and for all of the work you do to maintain it!

    Joe, great thanks for positive feedback.

    I added you to our SQL Server People list via https://github.com/ktaranov/sqlserver-kit/commit/8752f4547c613f3ccac59ec40b9aa8741379f6db, your blog is awesome, keep writing, our team read all articles.

  • Alan Burstein

    SSC Guru

    Points: 61039

    This article is awesome! Thanks for putting it together.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

Viewing 15 posts - 16 through 30 (of 37 total)

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