SQL Server Performance Forum – Threads Archive
SQL Server 2005 – Tempdb FullWe found that the tempdb was full in one of our production SQL server 2005.
We have tried to shrink the log file but the file hasnt been shrunk. The tempdb size is about 25 GB and used space is 24 GB. Could any one please help us? Thanks
Please go through this white paper:
http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx It discusses about monitoring and troubleshooting tempdb