#title DBCC 명령들
[[TableOfContents]]

가끔씩 쓰니까 잘 까묵는다..

|| DBCC명령 || 설명 ||
||DBCC DROPCLEANBUFFERS||Buffer Cache 비우기||
||DBCC FREEPROCCACHE||Plan Cache 비우기||
||DBCC TRACEON(7307,-1)||gargisur Fix up data while validating data length of remote columns 링크서버 원격쿼리시 데이타 유효성 수정||
* DBCC TRACEON(7307,-1)에서 -1은 전역설정

DBCC TRACEON (3604); -- Show DBCC output
DBCC SETCPUWEIGHT(1E0); -- Default CPU weight
DBCC SETIOWEIGHT(0.6E0); -- I/O multiplier = 0.6
DBCC SHOWWEIGHTS; -- Show the settings

DBCC FREESYSTEMCACHE('ALL')
DBCC FREESESSIONCACHE
DBCC FREEPROCCACHE

==== 참고자료 ====
 * [http://www.extremeexperts.com/sql/articles/ListDBCCCommands.aspx List Available DBCC Commands]
 * [http://blog.sqlauthority.com/2007/05/15/sql-server-dbcc-commands-list-documented-and-undocumented/ SQL SERVER – DBCC commands List – documented and undocumented]
 * [http://blogs.msdn.com/psssql/archive/2009/05/11/how-do-i-determine-which-dump-triggers-are-enabled.aspx How Do I Determine Which Dump Triggers Are Enabled]