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 Friday, July 6, 2012 6:42 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, April 17, 2014 1:41 AM
Points: 170, Visits: 1,400
Very nice, keep it coming!

Cheers,

JohnA

MCM: SQL2008
Post #1326045
Posted Thursday, July 12, 2012 4:56 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 10:49 PM
Points: 268, Visits: 898
All in place & published now.
Post #1329224
Posted Wednesday, September 26, 2012 4:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 12, 2014 7:54 AM
Points: 3, Visits: 107
Hi,

How can I see default enabled trace flags in Sqlserver..??
Post #1364566
Posted Wednesday, September 26, 2012 5:11 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 10:49 PM
Points: 268, Visits: 898
The command is DBCC TraceStatus.
You can details here
http://msdn.microsoft.com/en-us/library/ms187809.aspx
Post #1364573
Posted Thursday, October 11, 2012 8:12 AM
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
While trace flag -T8038 has been noted, I think it deserves more information.
Hp has a support Document ID: c02110402 that explains it a bit more than the KB article

DESCRIPTION
ProLiant servers that have multiple processor cores and that are running Microsoft SQL Server 2005 SP3 or SQL Server 2008 may stop responding when under a heavy I/O processing load. If Automatic Server Recovery (ASR) is enabled on these servers, the server may reboot when the server stops responding.
SQL Server 2005 SP3 and SQL Server 2008 use mmtimer (Multimedia) timer rather than the RDTSC timer, which changes the clock granularity (to 1ms). This change may result in clock-drift or an unresponsive server if the server uses enhanced power management technologies that change CPU frequencies.
Note: This issue may occur with any ProLiant server that supports power management technologies. Refer to the Affected Platforms included at the bottom of this advisory; however, other platforms may also be affected.
SCOPE
Any ProLiant server that supports power management technologies is running SQL Server 2005 SP3 or SQL Server 2008 on Windows Server 2003.
Post #1371521
Posted Thursday, October 11, 2012 8:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 12, 2014 7:54 AM
Points: 3, Visits: 107
I have implemented fulltext search and Rebuild indexes for this scheduled every 5 mins and its working fine but for every 5 mins of running this job its going to write the below message in SQLServer Error Log.

Message
Changing the status to MERGE for full-text catalog "CatalogName" (7) in database "DbName" (5). This is an informational message only. No user action is required.

How can I avoid this,I mean I do not want to write this into SqlServer Error Log.I have searched for trace flags but I did not find related to this.
Post #1371531
Posted Thursday, October 11, 2012 9:52 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 3:44 PM
Points: 70, Visits: 511
This is not the thread to ask these questions.

Find the message number in master..sysmessages and then use sp_altermessage as appropriate.
Post #1371620
Posted Thursday, October 11, 2012 10:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 10:49 PM
Points: 268, Visits: 898
Thanks Tim, I'll add those in the next update.
Post #1371686
Posted Tuesday, April 23, 2013 6:45 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 11:08 AM
Points: 316, Visits: 1,117
Great article!!! I would change only one thing to make it easier to ready for all DBA levels. Think if you put the actual version of SQL Server like SQL 2000, SQL 2005, SQL 2008, etc. it would make it a better read. Other than that, it excellent!!

Thanks,

Rudy



Post #1445391
Posted Tuesday, April 23, 2013 7:35 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 10:49 PM
Points: 268, Visits: 898
Trying to keep it as concise as possible.
Post #1445420
« Prev Topic | Next Topic »

Add to briefcase «««34567»»

Permissions Expand / Collapse