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

Click to Enlarge



Picture showing the SQL query for which plan is created

Click to Enlarge




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