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 timestamp datatype in sybase?

466


What sybase central?

469


Why place tempdb and log on low numbered devices?

423


How would you lock a table in sybase?

503


What do you mean by adaptive server enterprise?

498






How do I move tempdb off of the master device?

465


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

419


Tempdb is full. How would you clear it?

497


What is sybase replication server?

538


Explain index covering?

484


How would you check the long running transaction?

482


State some of the products of sybase?

514


What is asa in sybase?

490


Differentiate between clustered and non-clustered index.

467


Is sybase relational database?

481