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

Why place tempdb and log on low numbered devices?

498


What is replication server? What is its role in sybase?

609


Is sybase owned by sap?

555


What is isql in sybase?

538


What is asa ultralite in sybase?

569






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

545


Explain asa, asa ultralite.

545


How do I configure the burn factor in sybase?

535


How to start sybase database in windows?

681


How can you change to get the decimal separator as comma instead of the decimal point (.)?

537


Explain coalesce.

577


Explain the difference between numeric and decimal data types in sybase.

554


List the merits of index covering.

551


The secondary truncation point is on. How would you clear the logsegment?

552


How to fix a munged log in sybase?

551