출처 : http://egloos.zum.com/tiger5net/v/5478969
1. Query Cache 확인하기
SELECT * FROM SYS.SYSCACHEOBJECTS
2. DMV를 이용한 Query Cache 확인하기 -- Proc(프로시져), Prepared(이미 컴파일 된 것으로 사용하는 쿼리), Adhoc(매번 재 컴파일)
SELECT TOP 1000 ST.TEXT, CP.CACHEOBJTYPE, CP.OBJTYPE, CP.REFCOUNTS, CP.USECOUNTS, CP.SIZE_IN_BYTES,CP.BUCKETID, CP.PLAN_HANDLE
FROM SYS.DM_EXEC_CACHED_PLANS CP
CROSS APPLY SYS.DM_EXEC_SQL_TEXT(CP.PLAN_HANDLE) ST
WHERE CP.CACHEOBJTYPE = 'Compiled Plan'
AND CP.OBJTYPE IN ('Adhoc','Proc','Prepared')
ORDER BY CP.OBJTYPE DESC, CP.SIZE_IN_BYTES DESC
3. Query Cache 삭제하기
DBCC FREEPROCCACHE
참고 : http://msdn.microsoft.com/ko-kr/library/ms187815.aspx
