????Trace Flag  834

??????? Microsoft Windows ????滺?????????????????SQL Server??÷???????????????????????

????Trace Flag  835

????????SQL Server 2005??2008??????????????????????????????????????????С??????????????????????

????Trace Flag  1118

????tempdb????????????????????????????SGAM?????????apply tempdb??best practice???????????????????????????????

?????ο??????http://blogs.msdn.com/b/psssql/archive/2008/12/17/sql-server-2005-and-2008-trace-flag-1118-t1118-usage.aspx

????Trace Flag  1204??1222

????????????????????????д??????????У?????1204?????????????У???1222????XML??????檔???????sp_readerrorlog???????

????Trace Flag  1211??1224

?????????????????????????????????????1211????????????????????????1224????????????????????????????????????out-of-locks????????????????????????1211????????????

????Trace Flag  2528

???????ò??????DBCC CHECKDB?? DBCC CHECKFILEGROUP??DBCC CHECKTABLE??????ζ???????????????????У?????????????????????????Щ?????????????Щ?????

????Trace Flag  3226

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

????Trace Flag  4199

???????У?2??????????????????????????Ч???????????Σ??????????????????????????ο???http://support.microsoft.com/kb/974006

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

????Trace Flag  806

?????????????ж???????????????????????п????????????????????

????2004-06-25 11:29:04.11 spid51 ???? 823????????? 24 ?????? 2

????2004-06-25 11:29:04.11 spid51 I/O ???? ????????? ?????????м????????????? SQL ServerMSSQLdatapubs.mdf e:Program ????е? 0x000000000b0000.

?????ο??????http://support.microsoft.com/kb/841776

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

????Trace Flag 818

???????д?????

???????? 818 ?????????????е???λ???????????????????? SQL Server ????????е?? 2??048 ?????д??????????????????????? I/O???????? 605??823 ?? 3448 ????????????????????????????к? (LSN) ?????д???б???б??????????????????????? LSN ????д???????????????????? SQL Server ????????м??????μ????????????? SQL Server д?????????????д??????????????д???????????? I/O ???????????????λ????????????????????????????????????????

?????ο??????http://support.microsoft.com/kb/826433Trace

????Flag 1200

????????????????????????????????????????????????????????￡?

????DBCC TRACEON(1200??-1)
????DBCC TRACEON(3604)
????DBCC TRACESTATUS

????SELECT * FROM AdventureWorks.person.Address

?????ο??????http://stackoverflow.com/questions/7449061/nolock-on-a-temp-table-in-sql-server-2008Trace

????Flag 1806

???????ü???????????????е???????????????????????????????????????????????????

????Trace Flag 3502

???????????????й?checkpoint????????????????????

???.?????????????Checkpoint

????Trace Flag 3505

?????????????????checkpoint??checkpoint?????????У?????Σ?????????

????С??

???????????????SQL Server?????????????????Щ????????????????????????????????????????????Щ???????????????????????????Σ??????飬????????????в??????á?????????????????????????????????Σ??????????????л????????????????????????????