1

I have made a maintenance plan for my db. This plan contains several tasks, i can choose that every task is for specific db.

But dbcc freeproccache does not have any mentioning about specific db. I'm worried that this procedure will be executed for all databases that my SQL server has.

How can i execute clearing of cache for a single database?

Improve this question

2 Answers 2

Reset to default
1

dbcc freeproccache functions at the Sql Server instance level, so yes, it does effect every database under a particular instance. To explicitly clear plans for a single database, you could run the command: DBCC FLUSHPROCINDB().

Improve this answer
0

I think you'd get better answers to this question on dba.stackexchange.com.

A simple explanation is that DBCC freeprocache is an instance level command, and it will affect all DBs on the same instance.

I need to know why you want to clear plans to give you a better answer to this question. What are you trying to solve?

Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.