How do you troubleshoot if your tempdb gets filled

Answer Posted / one of learner like you

#1:Try to find out the Active process that is filling up
the temp db space.
#2:Same time can request for the addition of the space to
temp db.
#3:Keeping another temp db for trouble shoot always
advisable.

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Alternative to row at a time processing in sybase?

404


What will cause the size of a stored procedure to grow in sybase?

418


How do I find the oldest open transaction in sybase?

466


Explain index covering?

484


How do I make isql secure in sybase?

464






How do I create a database in sybase central?

470


What are the catches?

501


What is the depth of triggers?

506


Explain defncopy and it's usage?

564


What measures are there to increase the db space?

481


Explain asa, asa ultralite.

480


You need to multiply all values of a single column. How would you do that?

479


How to manually drop a table in sybase?

450


Are there any alternatives to isql in sybase?

466


Can you create your own sps for system wise?

523