Help with database 'tempdb' has reached its size quota

Question

Hi, please help with below error. is there a command to clear or reduce the current size of tempdb??

Msg 50000, Level 17, State 2, Procedure xxx, Line 5315 [Batch Start Line 0]
xxx:Line 2940:The database 'tempdb' has reached its size quota. Partition or delete data, drop indexes, or consult the documentation for possible resolutions.

Answer 1

Hi @Henry Fung

For Azure SQL Database tempdb issue, please check below community blog for possible mitigation options.

The blog includes queries to monitor tempdb usage.

Resolve tempdb-related errors in Azure SQL Database - Microsoft Community Hub

Thank you!

Answer 2

try this:

https://learn.microsoft.com/en-us/sql/relational-databases/databases/shrink-tempdb-database?view=sql-server-ver16&viewFallbackFrom=azuresqldb-current

Answer 3

this has been answered many times... see [https://learn.microsoft.com/en-us/answers/questions/249109/error-the-tempdb-has-reached-its-size-(db-in-azure?childtoview=251609#comment-251609](https://learn.microsoft.com/en-us/answers/questions/249109/error-the-tempdb-has-reached-its-size-(db-in-azure?childtoview=251609#comment-251609)