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 ««12345»»»

SQL Server Trace Flags Expand / Collapse
Author
Message
Posted Thursday, June 3, 2010 5:09 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 27, 2014 11:16 AM
Points: 265, Visits: 844
Hey thanks man.
Post #931996
Posted Thursday, June 3, 2010 7:19 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 1, 2013 8:10 AM
Points: 445, Visits: 840
I also use 8765 knowing only that it fixes the issue of a field returning the wrong data length in ODBC. I would love to know if it effects perfomance of other queries run while it is on.






Post #932113
Posted Thursday, June 3, 2010 7:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 1, 2010 11:33 AM
Points: 4, Visits: 17
Trace flag 8002 treats an affinity mask like a process affinity.

See this KB for further information: http://support.microsoft.com/kb/818769
Post #932134
Posted Thursday, June 3, 2010 8:05 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 5:51 AM
Points: 6,266, Visits: 2,028
This is great!
I really don't like M$ attitude about trace Flags. Why do we have to go through so much trouble to know (and compile) these things?



* Noel
Post #932154
Posted Thursday, June 3, 2010 8:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 16, 2010 1:29 PM
Points: 11, Visits: 28
What version(s) does this list apply to?
Post #932166
Posted Thursday, June 3, 2010 1:35 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 24, 2014 5:59 AM
Points: 70, Visits: 498
Trace flag 8030 for SQL 2005

http://support.microsoft.com/kb/917035
FIX: Query performance may decrease after SQL Server 2005 has been running for a while

Symptoms
Consider the following scenario. A server has been running for a while. Then, you run a query in Microsoft SQL Server 2005. In this scenario, the query performance may be slow.
<...>
This problem occurs only on 64-bit servers that have more than 16 gigabytes (GB) of physical memory.

Resolution
You do not have to restart the computer after you apply this hotfix. However, after you apply this hotfix, you must add the -T8030 option as a SQL Server startup parameter to enable trace flag 8030. Then, you must restart the SQL Server service for the hotfix to take effect.
Post #932380
Posted Thursday, June 3, 2010 2:44 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 7:23 AM
Points: 28, Visits: 475
Here are two useful reference URLs for trace flag 610:
http://blogs.msdn.com/b/sqlserverstorageengine/archive/2008/10/24/new-update-on-minimal-logging-for-sql-server-2008.aspx
http://msdn.microsoft.com/en-us/library/dd425070%28SQL.100%29.aspx
Post #932436
Posted Thursday, June 3, 2010 8:34 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 27, 2014 11:16 AM
Points: 265, Visits: 844
Hey all mrpolecat, chairleg, Ron Klimaszewski and Bennett Scharf; appreciate all your contributions & I'm certainly looking to include all this in the next update.
Post #932531
Posted Friday, June 4, 2010 3:11 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 30, 2010 1:29 AM
Points: 46, Visits: 66
traceflag 9059; was for sql server 2000 SP4 (to obtain again SP3 level behaviour for specific cases)
see http://support.microsoft.com/?id=899976



Post #932682
Posted Friday, June 4, 2010 3:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 27, 2014 11:16 AM
Points: 265, Visits: 844
Thanks FVC, its on the list now.
Post #932693
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse