How do you troubleshoot if your tempdb gets filled
Answer Posted / bindu
if the system temp db gets filled, even sa cannot get
connected to that temp db to check which processes are
blocking, in order to avoid this , a good concept of
multiple temp dbs can be implemented and we can create temp
dbs and assign newly created temp db to sa, so that sa
could get the info of the processes that is blocking temp
db, ab=nd by using lct_admin or some other commands we can
abort that blocking transaction.
Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
What are triggers? Why do we use them? Diff types of triggers? What are magic tables?
How to delete unix files which are more than 3 days old?
You need to manipulate varbinary columns in sybase. How would you do that?
Explain about sybase 365?
Differentiate between replication server and sql remote?
Explain procedure cache and data cache in sybase.
How does sybase replication work?
How to fix a munged log in sybase?
How do I start sybase control center in windows?
Can I partition any table in sybase ?
Tempdb is full. How would you clear it?
What measures are there to increase the db space?
How do I open sybase control center?
How do I set a password to be null?
What is ceiling()?