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

Question

Ashutosh Patel · 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.

interview

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

Can you answer this question?

1 Answers

Clear the Cache in SQL

Clear Plan Cache

Clear Data Cache

Clear the Session Cache