Post reply

Trace Flags

  • June 30, 2011 at 8:26 pm

    #74228

    Comments posted to this topic are about the item Trace Flags

  • June 30, 2011 at 8:30 pm

    #1346833

    I don't think there's any confusion about today question. Thanks Steve.

    --------------------------------------------------------------------------------------
    Hai Ton
    My Db4Breakfast blog.

  • June 30, 2011 at 10:02 pm

    #1346849

    Thanks, it is a good question.

    M&M

  • June 30, 2011 at 11:26 pm

    #1346864

    Easy question to finish the workweek. Thanks Steve!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • July 1, 2011 at 1:27 am

    This was removed by the editor as SPAM

  • July 1, 2011 at 2:07 am

    #1346904

    Thanks for the question

    Interesting area, but why would someone usually use trace flags in practice;

    I have not used them yet so I did not had the chance to understand their value.

    Have a nice day,

    Iulian

  • July 1, 2011 at 2:12 am

    #1346905

    Iulian -207023 (7/1/2011)

    Thanks for the question

    Interesting area, but why would someone usually use trace flags in practice;

    I have not used them yet so I did not had the chance to understand their value.

    Have a nice day,

    Iulian

    There are many undocumented trace flags that you can for example use to start up the server in a specific state.

    An example of a documented trace flag:

    if you start up SQL Server Express with trace flag 7806, you can enable a DAC connection.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • July 1, 2011 at 4:06 am

    #1346926

    Thanks Steve - I'm glad to say for all concerned that there is no controversy today.

  • July 1, 2011 at 4:36 am

    #1346934

    Nice question!

  • July 1, 2011 at 4:59 am

    #1346940

    really, you are greate teacher, steve!!!! good question!!!!!!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

  • July 1, 2011 at 5:53 am

    #1346964

    Iulian -207023 (7/1/2011)

    Thanks for the question

    Interesting area, but why would someone usually use trace flags in practice;

    I have not used them yet so I did not had the chance to understand their value.

    Have a nice day,

    Iulian

    Two quick examples of use in practice: - trace flags 1204 and 1222 can be quite useful when chasing down deadlocks, and 3004 and 3605 are quite useful when you need extensive logging to identify an issue with backups.

    -Ki

  • July 1, 2011 at 8:45 am

    #1347064

    Koen Verbeeck (7/1/2011)

    Iulian -207023 (7/1/2011)

    Thanks for the question

    Interesting area, but why would someone usually use trace flags in practice;

    I have not used them yet so I did not had the chance to understand their value.

    Have a nice day,

    Iulian

    There are many undocumented trace flags that you can for example use to start up the server in a specific state.

    An example of a documented trace flag:

    if you start up SQL Server Express with trace flag 7806, you can enable a DAC connection.

    There are many documented ones of much help as well.

    For instance, to help optimize tempdb usage traceflag 1118 is very useful

    If your stored procedures are having problems with parameter sniffing you can disable it with Traceflag 4136


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • July 1, 2011 at 9:09 am

    #1347082

    nice question

    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

  • July 1, 2011 at 9:57 am

    #1347137

    Nice question and a nice start to the holiday weekend here in the U.S.

  • July 1, 2011 at 11:12 am

    #1347212

    Thanks for the question.

    ---------------------------------------------------------------------
    Use Full Links:
    KB Article from Microsoft on how to ask a question on a Forum

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

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