x

temp db error

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

asked Oct 10, 2011 at 07:55 AM in Default

pits gravatar image

pits
830 79 91 92

Search on Google for "tempdb full" should point you to alot of solutions, or things to check.
Oct 10, 2011 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, 2011 at 08:31 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.3k 74 78 108

Oct 10, 2011 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, 2011 at 08:34 AM

alexsdba gravatar image

alexsdba
221 1 1 4

Not for tempdb.
Oct 10, 2011 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, 2011 at 10:34 AM alexsdba
@alexsdba - Oh, I know that problem! :-)
Oct 10, 2011 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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x56
x6
x2

asked: Oct 10, 2011 at 07:55 AM

Seen: 816 times

Last Updated: Oct 10, 2011 at 07:55 AM