How do I free up space on tempdb?

Question

To remove additional files in tempdb, use the ALTER DATABASE command by using the REMOVE FILE option. Use the DBCC SHRINKDATABASE command to shrink the tempdb database.

What should I do if my temp DB is full?

CREATE the necessary space by dropping objects in the filegroup, adding additional files to the filegroup,or setting autogrowth on for existing files in the filegroup. When investigating a TempDB issue like this, most simply restart the SQL Server instance.

What causes tempdb to fill up?

As Fessor said, it is likely due to some query process (user initiated or scheduled or other) that is not properly completing and releasing its usage of temp database space. DON'T shrink tempdb - you're wasting effort. Restarting the database engine clears it out.

How do I reduce tempdb without resetting?

Shrinking tempdb without restarting SQL Server1First off, the easy way out. It's worth mentioning. ... 2DBCC DROPCLEANBUFFERS. Clears the clean buffers. ... 3DBCC FREEPROCCACHE. ... 4DBCC FREESYSTEMCACHE. ... 5DBCC FREESESSIONCACHE. ... 6.. and finally, DBCC SHRINKFILE. ... 7A word about shrinking database files.Shrinking tempdb without restarting SQL Server | sqlsunday.com

Expert · Answer