The tempdb is full and ldf is started growing very fast , due to this the disk is about to run out of space
i run the sqldiag now what next? is there any other solution to control this?thank you
asked Oct 10, 2011 at 07:55 AM in Default
If TempDB is filling then there must be a transaction running somewhere that is taking a long time to complete. Try using sp_who and sp_lock to see if this is the case.In an emergency scenario you could add files onto TempDB to allow the transaction to complete but this int the best way to resolve the issue. You should make sure the transaction causing the problem should be run and why it is taking so long.
answered Oct 10, 2011 at 08:31 AM