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





Click to Enlarge




Click to Enlarge




How to clear plan cache




Use Master
Go
dbcc freeproccache



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

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250