How do you troubleshoot if your tempdb gets filled

Answer Posted / prabhu

Do any of the following
1. restart the sybase database server
2. alter the size of the tempdb

Is This Answer Correct ?    13 Yes 24 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to save space when inserting rows monotonically?

456


How would you configure identities in sybase?

515


How do you view log files in sybase?

520


How to pad with leading zeros an int or smallint in sybase?

449


Which should I use, repagent or ltm in sybase?

558






List the merits of index covering.

484


Explain bind cache?

546


How to remove row affected and dashes?

441


What are the operating systems in which sybase could take its presence?

478


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

518


Differentiate between clustered and non-clustered index.

467


Are you doing the updates from within a cursor?

481


How do I tell which tables have identities in sybase?

478


You need to add a notnull column in a table by using alter command (without using default command). How would you do that?

498


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

479