Details of Trace Flags

  • Hello Expertz!,

    Found the following trace Flags Enabled in SQL Server 2016. Any idea what are these used for? 

    9801
    9802
    9803
    9804
    9821
    9826
    9827
    9828
    9883
    9905

    Tanx 😀

  • These flags were enabled after the install of security patch KB4293807.

    Microsoft is not publicly stating what the effects of the enabled trace flags were, but has to pulled KB4293807 and replaced it with KB4458621.

    Tanx 😀

  • Eswin - Wednesday, September 12, 2018 1:03 AM

    These flags were enabled after the install of security patch KB4293807.

    Microsoft is not publicly stating what the effects of the enabled trace flags were, but has to pulled KB4293807 and replaced it with KB4458621.

    Very interesting - Thanks a lot for posting back!!
    You used to be able to find out information on some trace flags by checking Sybase documentation but that doesn't work as well anymore. But I did find a post of someone asking if they could implement "DBCC TRACEON((9801, 9802 ... IN ASE 11.5 for logging client activity" so that could be a clue about the intention of those.
    Or they are completely different now between Sybase and SQL Server.

    Sue

Viewing 3 posts - 1 through 2 (of 2 total)

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