TempDB full how can i resolve?

Question

TempDB full how can resolve without restart services?

Answer 1

Restarting SQL Server service is an easy way, because TempDB get recreated on initial file size. But in a 24/7 enviroment hardly possible.

You can try to shrink the database, see
https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkdatabase-transact-sql?view=sql-server-ver16

https://learn.microsoft.com/en-us/sql/relational-databases/databases/shrink-a-database?view=sql-server-ver16

Don't work always. Other option is to add additional database file on disk with enough free space.

See https://learn.microsoft.com/en-us/sql/relational-databases/databases/tempdb-database?view=sql-server-ver16

Answer 2

If tempdb is genuinely full, you can shrink it.

But it is not common to see tempdb to be full for a longer period of time, as the cause is some operation that requires workspace in tempdb, and when that operation fails, the space it has allocated will be released. In this case, you can try tio shrink tempdb, but what's the point? It's not full any more, so there is no issue.

If tempdb is full and remains full, this would be because someone has created a large table and is clinging to that table. In that case, you would need to find that table and drop it. (And possibly talk kindly with the user behind it.)

Answer 3

Hi @Sanjay Kumawat,

You may also check Shrink the tempdb database.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.