Sep
4
2014

All about SQL Server Trace flags – Links

 

While doing search for SQL Server 2005 trace flags found few good links which greatly describe the info in detail, please use as per your requirement, most of them may be applicable to higher version of SQL Server as well.

 

Flags can be set for Session or Global (some are startup) levels though for later some can only be switched at startup using –T (you are suggested to avoid –t which turns on other internal flags) otherwise DBCC TRACEON/TRACEOFF (FlagNo,(-1) optional ) comes quite handy.

 

Reference Links:

SSC — http://www.sqlservercentral.com/articles/trace+flags/70131/

MSDN — http://social.technet.microsoft.com/wiki/contents/articles/13105.trace-flags-in-sql-server.aspx

 

Download PDF

About the Author: Nitin G

Indian born, trekker, biker, photographer, lover of monsoons. I've been working full time with SQL Server since year 2005 and blogs to post the content aquired during my research on new topics or fixing issues faced by me as a DBA while working in different kind of projects, hope some of my posts may helps others in SQLDBA community. Everything you read on my blog is my own personal opinion and any code is provided "AS-IS" with no warranties!

Leave a comment

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 174 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

May 2019
M T W T F S S
« Nov    
 12345
6789101112
13141516171819
20212223242526
2728293031  

View Post by Categories

%d bloggers like this: