????????????????

????????DBA?????????Trace Flag????????SQL Server?????????????????????????￡?Trace Flag?????????????????У??????????????????￡????????Щ?????????????????SQL Server???????

????????????????Trace Flag?????

???????????????????????????????SQL Server???Щ?????

?????????????岻???????Trace Flag?????????????SQL Server??????????????DBA??Trace Flag???????Щ??????????????????????????в??п??????Trace Flag???????????????????????????Trace Flag???????????????????????????????????????????????????

????Important??Trace Flag??????????????????????Trace Flag???????????Apply??????Best Practice??

??????ο????????

???????????????????????????

????1?????DBCC????

???????????DBCC??????????????????????????????????????????????????????????????????????????????????

?????? DBCC TRACEON(2203??-1)

?????? DBCC TRACEOFF(2203??1)

?????? DBCC TRACESTATUS

???????У?TRACEON??TRACEOFF??????????????????????Χ??1??Session Scope??-1??Global Scope???????????????????????Session Scope??

??????????????????????????????SQL Server???????????DBCC????????ЩFlag???????

EXEC sp_procoption @ProcName = '<procedure name>'
    ?? @OptionName = ] 'startup'
    ?? @OptionValue = 'on';

????????洢???????????sp_procoption?洢???????SQL Server???????????????С?

????????????????????????????е?????????????DBCC?????????????Flag 835??????????????????

????2???????SQL Server???ù??????????

?????????????????????????????????????????????????Global Scope??????-T#??????1??T??????2??T??????3??

????3????????????

???????????????2???С??????????

?????Щ???????????п?????????????

????Trace Flag 610

?????????????????????????????????????????best practice?????????????????????VLF??????????????洢????????????????????????????????????????

?????ο??????

????http://msdn.microsoft.com/en-us/library/dd425070.aspxhttp://blogs.msdn.com/b/sqlserverstorageengine/archive/2008/10/24/new-update-on-minimal-logging-for-sql-server-2008.aspx