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