연구개발/SQL2008

DBCC 명령문

HEAD1TON 2010. 5. 6. 12:56

DBCC TRACEON / TRACEOFF / TRACESTATUS

DBCC SQLPERF(LOGSPACE / IOSTATS / LRUSTATS / NETSTATS)

DBCC OPENTRAN

DBCC CHECKDB

DBCC INPUTBUFFER / OUTPUTBUFFER

DBCC PROCCACHE

DBCC SHOWCONFIG

DBCC SHOW_STATISTICS

DBCC USEROPTIONS

DBCC dllname(FREE)

DBCC INDEXDEFRAG

DBCC PINTABLE / UNPINTABLE

DBCC DROPCLEANBUFFERS

DBCC FREEPROCCACHE