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

Are you doing the updates from within a cursor?

477


How do I exclude a column in sybase?

451


How do I open sybase control center?

499


How do I correct time slice -201?

436


How would you configure identities in sybase?

511






What is the default size of master database in sybase?

466


Can two tasks be assigned to the same partition in sybase?

446


What is raid and sybase?

517


Explain intimate shared memory(ism)

523


When should I execute an sp_recompile in sybase?

463


What are table partitions? How is it different with ase 15.0 version?

469


How to check sybase database status in linux?

469


What is the difference between replication server and sql remote in sybase?

477


Compare in and exists?

538


What is the default table size in sybase?

469