Home Forums Article Discussions Article Discussions by Author Discuss content posted by yusufanis SQL Server Trace Flags RE: SQL Server Trace Flags

  • July 5, 2012 at 1:11 pm

    #1509313

    Trace Flag: 2470

    Purpose: Slow performance when an AFTER trigger runs on a partitioned table in SQL Server 2008 R2 or in SQL Server 2012

    KB Article: http://support.microsoft.com/kb/2606883

    First Added: SQL 2008 R2 SP1 CU3 or SQL 2012 CU1

    Versions: SQL 2008 R2, SQL 2012

    Trace Flag: 3023

    Purpose: How to enable the CHECKSUM option if backup utilities do not expose the option

    KB Article: http://support.microsoft.com/kb/2656988

    First Added: SQL 2005

    Versions: SQL 2005, SQL 2008, SQL 2008 R2, SQL 2012

    Trace Flag: 3042

    Purpose: Don't pre-expand compressed backup at start of backup process

    KB Article: http://support.microsoft.com/kb/2001026

    First Added: SQL 2008

    Versions: SQL 2008, SQL 2008 R2

    Trace Flag: 3101

    Purpose: Slow performance when you restore a database in SQL Server 2008 R2, in SQL Server 2008 or in SQL Server 2012 if CDC is enabled

    KB Article: http://support.microsoft.com/kb/2567366

    First Added: SQL 2008 SP3 CU5, SQL 2008 R2 CU10, SQL 2012 CU2

    Versions: SQL 2008+

    Trace Flag: 4123

    Purpose: A query that has many outer joins takes a long time to compile in SQL Server 2005

    KB Article: http://support.microsoft.com/kb/943060

    First Added: SQL 2005 SP2 CU4

    Versions: SQL 2005

    Trace Flag: 4134

    Purpose 1: Incorrect results or constraint violation when you run a SELECT or DML statement that uses the row_number function and a parallel execution plan in SQL Server 2008

    Purpose 2: Results may change every time that you run a parallel query in SQL Server 2005, in SQL Server 2008, or in SQL Server 2008 R2 if the query uses a ranking function and if the computer has eight or more CPUs

    KB Article 1: http://support.microsoft.com/kb/2589980

    KB Article 2: http://support.microsoft.com/kb/2546901

    First Added: SQL 2008 CU6 or SQL 2008 SP1 CU2

    Versions: SQL 2008

    Trace Flag: 8010

    Purpose: SQL Server services cannot be stopped on a computer that has SQL Server 2008 R2 Express Edition installed

    KB Article: http://support.microsoft.com/kb/2633271

    First Added: SQL 2008 R2 SP1 CU4

    Versions: SQL 2008 R2

    Trace Flag: 9485

    Purpose: Revert original permissions for DBCC SHOW_STATISTICS in SQL 2012

    KB Article: http://support.microsoft.com/kb/2683304

    First Added: SQL 2012 CU2

    Versions: SQL 2012