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

How do I capture a process s sql in sybase?

512


Explain index covering? List its merits.

500


What do you mean by deferred update in sybase?

519


How do you use workspace in sybase?

509


What causes re-resolution of a stored procedure in sybase?

476






What is raid and sybase?

517


What are the advantages that you can get from mainframe connect in sybase?

479


what is the difference between an ltm and a repagent in sybase?

475


Using large raw partitions with replication server on unix in sybase?

504


Differentiate between db-lib and ct-lib?

504


Explain about sybase 365?

489


Explain procedure cache?

519


How do I correct time slice -201?

437


Alternative to row at a time processing in sybase?

413


What is the depth of triggers?

506