How do you troubleshoot if your tempdb gets filled

Answer Posted / one of learner like you

#1:Try to find out the Active process that is filling up
the temp db space.
#2:Same time can request for the addition of the space to
temp db.
#3:Keeping another temp db for trouble shoot always
advisable.

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What command helps you to know the process running on this port, but only su can run this command?

488


What is this tds protocol in sybase?

485


Explain about sybase 365?

489


Must I use multiple devices to take advantage of partitions in sybase?

473


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

478






What is the difference in storage type of numeric and decimal data types in sybase ?

510


How to start sybase database in windows?

593


Explain relationship between jdbc and sybase.

516


Why place tempdb and log on low numbered devices?

425


How do you check database space? What measures are there to increase the db space?

513


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

479


Explain procedure cache and data cache in sybase.

473


Can I use a named pipe to bcp/dump data out or in in sybase?

591


We have lost the sa password, what can we do?

491


What is cmaxpktsz good for in sybase?

474