Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««34567»»»

SQL Server Trace Flags Expand / Collapse
Author
Message
Posted Wednesday, August 31, 2011 4:43 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, October 11, 2014 7:56 AM
Points: 113, Visits: 617
I have not see this one yet. This one is to claims to solve memory pressure on 32 bit systems using the CLR.

Failed processing batch due to Thread was being aborted.

Article ID: 969962 - Last Review: June 18, 2010 - Revision: 2.0
Various memory errors are logged to SQL Server error log when using SQL CLR objects
http://support.microsoft.com/kb/969962


"giving more memory to SQL CLR by increasing the 'MemToLeave' or 'Non buffer pool memory' to 384 MB. This can be done by adding the -g384 switch to the startup parameters "

I also don't understand why they say use -g instead of -T which is what I normally would use.
Post #1168426
Posted Monday, November 28, 2011 1:39 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:42 AM
Points: 6,743, Visits: 8,515
Trace Flag 8017 upgrade version conflict http://social.msdn.microsoft.com/Forums/eu/sqlexpress/thread/dd6fdc16-9d8d-4186-9549-85ba4c322d10

and http://connect.microsoft.com/SQLServer/feedback/details/407692/indicateur-de-trace-8017-reported-while-upgrading-from-ssee2005-to-ssee2008


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1212741
Posted Tuesday, November 29, 2011 2:12 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:45 AM
Points: 268, Visits: 896
Thanks ALZDBA this is currently marked with space in my list here, will soon update.
Post #1213014
Posted Sunday, January 29, 2012 8:01 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:45 AM
Points: 268, Visits: 896
Any one needed this after CTP3 of 2012 ?
tf 9532 to get more than 1 availability group replica in CTP3 Scope Startup.
http://connect.microsoft.com/SQLServer/feedback/details/682581/denali-hadron-read-only-routing-url-is-not-yet-implemented
Post #1243379
Posted Thursday, July 5, 2012 12:13 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 30, 2014 10:45 AM
Points: 70, Visits: 509
Trace Flag: 7608
Purpose: Performance fix for slow full text population with a composite clustered index
KB Article: http://support.microsoft.com/kb/938672
First Added: SQL 2005 SP2 CU3
Versions: SQL 2005, SQL 2008, SQL 2008 R2, SQL 2012

Post #1325618
Posted Thursday, July 5, 2012 12:24 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 30, 2014 10:45 AM
Points: 70, Visits: 509
Trace Flag: 1140
Purpose: Continuous tempdb growth after upgrading SQL 2005 pre-SP2 to SP3/SP4 or to SQL 2008 or newer
KB Article: http://support.microsoft.com/kb/2000471
First Added: SQL 2005 SP2 build 3166
Versions: SQL 2005 SP3+, SQL 2008, SQL 2008 R2, SQL 2012
Post #1325627
Posted Thursday, July 5, 2012 1:11 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 30, 2014 10:45 AM
Points: 70, Visits: 509
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
Post #1325654
Posted Thursday, July 5, 2012 1:14 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 30, 2014 10:45 AM
Points: 70, Visits: 509
New 4199 Fixes:

KB2276330: The "CHANGETABLE" function is slow in SQL Server 2008 and in SQL Server 2008 R2

KB2698639: Performance of a SELECT statement that contains a LIKE operator and an ESCAPE clause is low in SQL Server 2008 R2

KB2649913: Performance might decrease when you run a query that uses the sp_cursoropen stored procedure after you upgrade from SQL Server 2005 to SQL Server 2008 or to SQL Server 2008 R2 or to SQL Server 2012

KB2260502: Query performance decreases after you upgrade to SQL Server 2008 or SQL Server 2008 R2 from SQL Server 2000 if the query uses a user-defined scalar function
Post #1325659
Posted Thursday, July 5, 2012 1:24 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 30, 2014 10:45 AM
Points: 70, Visits: 509
Improvements for the DBCC CHECKDB command may result in faster performance when you use the PHYSICAL_ONLY option

Trace Flag: 2549
Purpose: Parallel CHECKDB operations when using mount points
KB Article: http://support.microsoft.com/kb/2634571
First Added: SQL 2008 SP2 CU 9, SQL 2008 SP3 CU4, SQL 2008 R2 CU11, SQL 2008 R2 SP1 CU4, SQL 2012 RTM
Versions: SQL 2008, SQL 2008 R2, SQL 2012


Trace Flag: 2562
Purpose: Forces CHECKDB to use a single batch (may use more tempdb space); reduce contention on DBCC_MULTIOBJECT_SCANNER latch
KB Article: http://support.microsoft.com/kb/2634571
First Added: SQL 2008 SP2 CU 9, SQL 2008 SP3 CU4, SQL 2008 R2 CU11, SQL 2008 R2 SP1 CU4, SQL 2012 RTM
Versions: SQL 2008, SQL 2008 R2, SQL 2012
Post #1325667
Posted Thursday, July 5, 2012 5:26 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:45 AM
Points: 268, Visits: 896
Hey, thanks a lot.
I'll verify & add these to the main list.
Post #1325790
« Prev Topic | Next Topic »

Add to briefcase «««34567»»»

Permissions Expand / Collapse