Skip to content

Instantly share code, notes, and snippets.

@ritacse

ritacse/Cache Clear in SQL

Last active December 31, 2017 11:25
Show Gist options
  • Save ritacse/3d7d8391f5ab928f3087aba30f9d1cb5 to your computer and use it in GitHub Desktop.
Save ritacse/3d7d8391f5ab928f3087aba30f9d1cb5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Cache Clear in SQL
/*Removes all elements from the plan cache, removes a specific plan from
the plan cache by specifying a plan handle or SQL handle,
or removes all cache entries associated with a specified resource pool.*/
EXEC DBCC FREEPROCCACHE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment