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 03, 2010 5:09 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 11:13 PM
Points: 264, Visits: 822
Hey thanks man.
Post #931996
Posted Thursday, June 03, 2010 7:19 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Wednesday, May 01, 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 03, 2010 7:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 01, 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 03, 2010 8:05 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 8:03 PM
Points: 6,266, Visits: 2,027
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 03, 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 03, 2010 1:35 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, April 10, 2014 2:11 PM
Points: 69, Visits: 480
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 03, 2010 2:44 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, April 13, 2014 8:42 AM
Points: 28, Visits: 468
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 03, 2010 8:34 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 11:13 PM
Points: 264, Visits: 822
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 04, 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 04, 2010 3:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 11:13 PM
Points: 264, Visits: 822
Thanks FVC, its on the list now.
Post #932693
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse