연구개발/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