DataBaser.Net: DBCC명령들

1 참고자료

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

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

[edit]

1 참고자료 #

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

Contents

1 참고자료 #