none
Trace flag 8295

    Question

  • Hi,

    Does anyone have where trace flag 8295 is used for. I found it active on a customer server, SQL Server 2008 R2 SP2 Enterprise Edition, but I can't figure out the purpose of it. When I search the internet, nobody seems to know this trace flag.

    Can anyone help me?

    Regards
    Pieter

    Tuesday, April 9, 2013 6:55 AM

Answers

  • Search TechNet for "SQL Server for ConfigMgr 2012, eBook and Top 10 Database Issues"

    NOTE* If you found 4199 or 8295 do not disable this trace flags as they are used by ConfigMgr.

    Trace Flag 4199 = Controls multiple query optimizer changes previously made under multiple trace flags. For more information, see this Microsoft Support article http://go.microsoft.com/fwlink/?LinkId=203012 Scope: global or session

    Trace Flag 8295 = 'Creates a secondary index on the identifying columns on the change tracking side table at enable time'. This allows creation of a secondary index for changetracking tables, which we heavily use for replication between Configuration Manager sites.

    Friday, October 17, 2014 11:20 AM

All replies

  • interesting... the most comprehensive list of trace flags I know if is http://social.technet.microsoft.com/wiki/contents/articles/13105.trace-flags-in-sql-server.aspx, and it's not on that...


    Thanks, Andrew

    Tuesday, April 9, 2013 7:38 AM
  • Hi Andrew,

    I know... Nobody seems to know it. I'm wondering if even the trace flag exists...

    Regards
    Pieter

    Tuesday, April 9, 2013 7:44 AM
  • If you have an account in Facebook, then you may join and post in the below group which is owned and managed by Microsoft SQL Server support team

    https://www.facebook.com/groups/213527572040350/

    or you could wait for some one from MSFT to look and answer to this thread


    Tuesday, April 9, 2013 7:56 AM
  • Hi,

    Does anyone have where trace flag 8295 is used for. I found it active on a customer server, SQL Server 2008 R2 SP2 Enterprise Edition, but I can't figure out the purpose of it. When I search the internet, nobody seems to know this trace flag.

    Can anyone help me?

    Regards
    Pieter

    Hi Pieter, you are right even Iam also not sure on this trace, where we do have N number of traces

    http://www.sqlservercentral.com/articles/trace+flags/70131/

    But not sure what for it is, how did this question raised from your end or did you used it this one or is that an question you are asking so?


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Tuesday, April 9, 2013 8:46 AM
  • Looks like it is SCCM 2012 installation that is adding 2 trace flags onto the SQL Server during installation...

    http://blog.andernetwork.com/2011/08/21/sccm-2012-beta-2-installation-error-failed-to-write-string-t8295-to-registry-on-sql-server/

    Still, what is it used for :) ?

    Regards
    Pieter

    Tuesday, April 9, 2013 8:52 AM
  • Search TechNet for "SQL Server for ConfigMgr 2012, eBook and Top 10 Database Issues"

    NOTE* If you found 4199 or 8295 do not disable this trace flags as they are used by ConfigMgr.

    Trace Flag 4199 = Controls multiple query optimizer changes previously made under multiple trace flags. For more information, see this Microsoft Support article http://go.microsoft.com/fwlink/?LinkId=203012 Scope: global or session

    Trace Flag 8295 = 'Creates a secondary index on the identifying columns on the change tracking side table at enable time'. This allows creation of a secondary index for changetracking tables, which we heavily use for replication between Configuration Manager sites.

    Friday, October 17, 2014 11:20 AM