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 would you check the long running transaction?

488


What is sybase ?

504


What is the stored procedure to view current lock and processes respectively?

535


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

493


What measures are there to increase the db space?

494






What you need to do is issue an ase kill command on the connection then un-suspend the db?

537


What are the catches?

513


What is the drawbacks of normalization?

565


Explain procedure cache and data cache in sybase.

477


Is sybase sql?

473


How would you improve throughput in sybase?

480


What do you mean by deferred update in sybase?

523


What are the best monitoring tools for the sybase database?

435


What does –i option do in sybase tools?

525


How do I create a database in sybase central?

481