How do you troubleshoot if your tempdb gets filled

Answer Posted / ajith prabhakaran

lct_admin (0,2) would abort all open transactions, or you
can go for altering the tempdb space. Multiple tempdb's is
a feature which can be implemented to minimize such issues
of tempdb getting full.

Is This Answer Correct ?    23 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the equivalent of oracle/db2 coalesce function in sybase?

479


How to take backup in sybase database in sap?

484


How to restore sybase database in sap?

494


Explain the role of replication server in sybase.

479


How to find the time taken for rollback of the processed?

513






Differentiate between db-lib and ct-lib?

501


What are the best monitoring tools for the sybase database?

422


What is the difference between db-lib and ct-lib in sybase?

449


What do you mean by sybase iq?

484


How would you fix a munged log in sybase ?

530


Explain intimate shared memory(ism)

523


Explain 'forcing an index' concept.

503


Explain timestemp datatype in sybase.

537


What are the main differences between 11.x and 12.x versions of sybase?

465


How do I exclude a column in sybase?

451