[À§·Î]

<¿øÀÎ>

<SQL¹®>

select ObjectName=object_name(objid), objtype, cacheobjtype,
refcounts, usecounts, pagesused, sqlbytes, sql ,* from master..syscacheobjects
where dbid = 7
order by ObjectName, objtype,sql

<Á¶Ä¡ »çÇ×>

  1. ÀÏ¹Ý SQL ¹®À» ÃÖ´ëÇÑ SP ·Î º¯°æ
  2. SPÀ» ÀçSP·Î ÀνÄÇÏÁö ¸øÇÏ´Â ¿øÀÎ Á¦°Å
  3. objtypeÀÇ "Adhoc" À» ÃÖ´ëÇÑ Á¦°Å

<±âŸ>

  1. DBCC freeproccache -- »ç¿ëÁßÀΠij½Ã¸¦ ¸ðµÎ »èÁ¦