How to clear all plans from a single database?

Question

I want to clear out the procedure cache for just one database, not the entire SQL Server. Is there a way?

Danilo Braga · Accepted Answer · 2016-09-02T18:44:20.520

DBCC FLUSHPROCINDB (<db_id>)

This command allows you to specify a particular database id, and then clears all plans from that particular database. Check more information here.

DBCC FREEPROCCACHE

This command removes all cached plans from memory

It is, of course, recommended that you don’t use these commands on your production servers, as it could impact the performance of your running applications. Usually, you want to keep plans in cache.

score 4 · Answer 2 · edited Apr 13 '17 at 12:42

4

Another way to clear cache is to use DBCC freesystemcache

DBCC FREESYSTEMCACHE ('userdatabase') -- cleans cache for specific user database

edited Apr 13 '17 at 12:42

Community

1

answered Sep 02 '16 at 19:18

Kin Shah

62,545
6
124
245

How to clear all plans from a single database?

2 Answers2