|
Hello, 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
(comments are locked)
|
|
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. Check also with -
Oct 10 '11 at 08:47 AM
ThomasRushton ♦
(comments are locked)
|
|
You need to BACKUP LOG [yourDb] TO DISK = N'BackupyourDb.trn' GO DBCC SHRINKFILE(yourdbldf_file, 1) and then figure out what's causing this Not for tempdb.
Oct 10 '11 at 08:44 AM
ThomasRushton ♦
Thank you Thomas i haven't had my coffee at the time of posting and thought it was a transaction log question :).
Oct 10 '11 at 10:34 AM
alexsdba
@alexsdba - Oh, I know that problem! :-)
Oct 10 '11 at 11:11 AM
ThomasRushton ♦
(comments are locked)
|
Search on Google for "tempdb full" should point you to alot of solutions, or things to check.