Remove Procedure Cache and Reset Wait Stats Remove all elements from the plan cache for the entire sql server instance
1 |
DBCC FREEPROCCACHE; |
Flush the cache and suppress the regular completion message
1 |
DBCC FREEPROCCACHE WITH NO_INFOMSGS; |
Remove all elements from the plan cache for a…