Articles → SQL SERVER → Plan Cache In Execution Plan

Plan Cache In Execution Plan










How To Check Plan Cache In SQL Server




Use Master 
Go 
select 
  * 
from 
  syscacheobjects




Picture showing the list of plans in the syscacheobjects table




Picture showing the SQL query for which plan is created





How To Clear Plan Cache




Use Master
Go
dbcc freeproccache



Posted By  -  Karan Gupta
 
Posted On  -  Thursday, April 2, 2015

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250