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
What command helps you to know the process running on this port, but only su can run this command?
What is this tds protocol in sybase?
Explain about sybase 365?
Must I use multiple devices to take advantage of partitions in sybase?
What are the operating systems in which sybase could take its presence?
What is the difference in storage type of numeric and decimal data types in sybase ?
How to start sybase database in windows?
Explain relationship between jdbc and sybase.
Why place tempdb and log on low numbered devices?
How do you check database space? What measures are there to increase the db space?
What are the advantages that you can get from mainframe connect in sybase?
Explain procedure cache and data cache in sybase.
Can I use a named pipe to bcp/dump data out or in in sybase?
We have lost the sa password, what can we do?
What is cmaxpktsz good for in sybase?