How do you troubleshoot if your tempdb gets filled

Answer Posted / sanjeev shekhar

use tempdb
go
sp_helpsegment "default"
go

Is This Answer Correct ?    4 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Are there any alternatives to isql in sybase?

552


Is sybase relational database?

555


How would you lock a table in sybase? What text command will you use for it?

556


What is the command for quitting from sybase?

545


What is difference between sybase and oracle?

549






When should I execute an sp_recompile in sybase?

550


Which should I use, repagent or ltm in sybase?

643


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

585


Explain index covering?

562


How do I pipe the output of isql to a file in sybase?

572


What is replication server? What is its role in sybase?

609


Can you create your own sps for system wise?

593


Are you doing the updates from within a cursor?

660


How do I move tempdb off of the master device?

535


What measures are there to increase the db space?

563