How to clear the cache in SQL Server Management Studio (SSMS)?

Question

Ashutosh Kumar Verma · Answer

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.
and

interview

How to clear the cache in SQL Server Management Studio (SSMS)?

Ashutosh Kumar Verma

Can you answer this question?

1 Answers

Clear the Cache in SQL

Clear Plan Cache

Clear Data Cache

Clear the Session Cache

Liked By