출처 :&nbsp;<a href="http://egloos.zum.com/tiger5net/v/5478969" target="_blank" class="tx-link">http://egloos.zum.com/tiger5net/v/5478969</a> 1. Query Cache 확인하기 SELECT&nbsp;*&nbsp;FROM&nbsp;SYS.SYSCACHEOBJECTS 2. DMV를 이용한 Query Cache 확인하기 -- Proc(프로시져), Prepared(이미 컴파일 된 것으로 사용하는 쿼리), Adhoc(매번 재 컴파일) SELECT&nbsp;TOP&nbsp;1000&nbsp;ST.TEXT,&nbsp;CP.CACHEOBJTYPE,&nbsp;CP.OBJTYPE,&nbsp;CP.REFCOUNTS,&nbsp;CP.USECOUNTS,&nbsp;CP.SIZE_IN_BYTES,CP.BUCKETID,&nbsp;CP.PLAN_HANDLEFROM&nbsp;SYS.DM_EXEC_CACHED_PLANS&nbsp;CPCROSS&nbsp;APPLY&nbsp;SYS.DM_EXEC_SQL_TEXT(CP.PLAN_HANDLE)&nbsp;STWHERE&nbsp;CP.CACHEOBJTYPE&nbsp;=&nbsp;'Compiled Plan'AND&nbsp;CP.OBJTYPE&nbsp;IN&nbsp;('Adhoc','Proc','Prepared')ORDER&nbsp;BY&nbsp;CP.OBJTYPE&nbsp;DESC,&nbsp;CP.SIZE_IN_BYTES&nbsp;DESC 3. Query Cache 삭제하기 DBCC&nbsp;FREEPROCCACHE 참고 :&nbsp;<a href="http://msdn.microsoft.com/ko-kr/library/ms187815.aspx" target="_blank" style="margin: 0px; padding: 0px; font-size: 13px; border: 0px; vertical-align: baseline; color: rgb(49, 128, 218); text-decoration: underline; font-family: '맑은 고딕', 'malgun gothic', 돋움, dotum, AppleGothic, sans-serif; line-height: 23px;">http://msdn.microsoft.com/ko-kr/library/ms187815.aspx</a>

MSSQL 캐시 날리기