Clearing Plan Cache

General 1 Minute

Clearing Plan Cache

SYNTAX :  DBCC FREEPROCCACHE

We can also clear the plan cache for a specific database or query.

To remove all the plans related a database
SYNTAX : DBCC FLUSHPROCINDB(<databaseid>)
EXAMPLE : DBCC FLUSHPROCINDB(7)

To remove plan for a specific query, pass the plan_handle as parameter.

SYNTAX : DBCC FREEPROCCACHE(<plan_handle>)
EXAMPLE : DBCC FREEPROCCACHE(0x05000700210F020740A1DBAA000000000000000000000000)

Published by SQLWhisperer

Hello Everyone. My intention of having this site is to have one repository location for my SQL Server Learning's. Most of the information here is already available on Web but I want to have it in one global location, so I can reference whenever I need . I would be more than happy, if you find anything on this blog useful. Also, Please use your own caution when running any code on your systems.Thank you for visiting.

Published