interview

Home / DeveloperSection / Interviews / How to clear the cache in SQL Server Management Studio (SSMS)?

Ask Question
Ashutosh Kumar Verma

Ashutosh Kumar Verma

Follow
Hi! This is Ashutosh Kumar Verma. I am a software developer at MindStick Software Pvt Ltd since 2021. I have added some new and interesting features to the MindStick website like a story section, audio section, and merge profile feature on MindStick subdomains, etc. I love coding and I have good knowledge of SQL Database.

Can you answer this question?

Answer

1 Answers

Ashutosh Kumar Verma

Ashutosh Kumar Verma

11-Oct-2024

Clear the Cache in SQL

Clearing the cache in SQL Server Management Studio (SSMS) generally refers to clearing the plan cache or data cache in SQL Server. Here is how you can do that,

Clear Plan Cache

Execute the below SQL Command to clear the execution plan cache,

DBCC FREEPROCCACHE;

Clear Data Cache

Execute the below SQL Command to clear the Data cache (butter pool),

DBCC DROPCLEANBUFFERS;

Clear the Session Cache

To clear the session cache, execute the below SQL command,

DBCC FREESESSIONCACHE;

Note- Clearing the cache may temporarily impact performance, as SQL Server will need to recompile execution plans and reload data into memory.

 

MindStick Training

Liked By