temp db error


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
more ▼

asked Oct 10 '11 at 07:55 AM in Default

pits gravatar image

830 73 91 92

Search on Google for "tempdb full" should point you to alot of solutions, or things to check.
Oct 10 '11 at 10:31 AM Shawn_Melton
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.
more ▼

answered Oct 10 '11 at 08:31 AM

Fatherjack gravatar image

Fatherjack ♦♦
41.2k 72 77 107

Oct 10 '11 at 08:47 AM ThomasRushton ♦
(comments are locked)
10|1200 characters needed characters left

You need to BACKUP LOG [yourDb] TO DISK = N'Backup\yourDb.trn' GO DBCC SHRINKFILE(yourdbldf_file, 1)

and then figure out what's causing this
more ▼

answered Oct 10 '11 at 08:34 AM

alexsdba gravatar image

221 1 1 4

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)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 10 '11 at 07:55 AM

Seen: 717 times

Last Updated: Oct 10 '11 at 07:55 AM