if Tempdb is full? what we have to do

Question

Post reply

if Tempdb is full? what we have to do

venkatb.dba

SSC Enthusiast

Points: 199
More actions
August 21, 2010 at 4:22 am

#226485

if Tempdb is full? what we have to do in sql dba
please help me?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

LutzM SSC Guru Points: 107049 More actions · Answer 1

It depends.

Is the system still able to run? If not, what error message do you get?

When was the last transaction log backup? Is there any schedule for log backups? If so, how often?

Is there any suspicious code causing tempDB to grow unexpected?

Is tempDB configured to grow up to a size limit?

Is there any transaction log monitoring process in place?

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Adiga One Orange Chip Points: 27284 More actions · Answer 2

LutzM (8/21/2010)
It depends.
When was the last transaction log backup? Is there any schedule for log backups? If so, how often?

LutzM looks like this is a typo, since the database in question is tempdb.

@venkat-2, there is nothing much you can do when tempdb is full, except for waiting for the open transaction to complete, worst case kill it (again it will take up space while rolling back). Ensure tempdb has "enough" room to grow.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 3

Interview question? Homework?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions