Unable to Shrink TempDB in SQL Server? Try These Steps

If you're struggling to shrink TempDB in SQL Server, executing the following commands might help. These queries will clear the plan cache, buffer pool, and unused cache entries, making it easier to shrink TempDB.

USE TempDB

GO

-- Clear the plan cache in the server

DBCC FREEPROCCACHE

GO

-- Clear buffers from the buffer pool

DBCC DROPCLEANBUFFERS

GO

-- Release all unused cache entries from all caches

DBCC FREESYSTEMCACHE ('ALL')

GO

After executing these commands, try shrinking TempDB again.

⚠ Note: Use these commands with caution in a production environment, as they may impact query performance temporarily.