Há um bom artigo aqui em este tópico (cerca de 3/4 do caminho da página). Aqui está um trecho:
In this example, the query runs for 3 minutes before we hit the 200MB file size limit, as shown in Figure 25, and get an error that the filegroup is full.
At this point the query fails, obviously, as will any other queries that need to use TempDB. SQL Server is still functioning properly, but as long as the temp table #HoldAll exists, TempDB will stay filled.
Your three options, as a DBA, are to:
- Restart SQL Server.
- Try to shrink the TempDB database.
- Find the errant query and eradicate it.