How do you troubleshoot if your tempdb gets filled
Answer Posted / prashant
when temp db gets filled
that means there are large number of open process that are
making log of temp db ful in this case we wont even able to
run sp_who
what we will do is :
lct_admin('abort',0,2)
it will kill all open transactions but still log remains
full
now we will alter & extend the database
Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
What is the equivalent of oracle/db2 coalesce function in sybase?
What is replication server?
Explain index covering? List its merits.
How would you configure identities in sybase?
Explain the structure of adaptive server enterprise?
Does sybase support row level locking?
How do I capture a process s sql in sybase?
How do you check database space? What measures are there to increase the db space?
What you need to do is issue an ase kill command on the connection then un-suspend the db?
What is this tds protocol in sybase?
Is sybase a database? Explain.
How to save space when inserting rows monotonically?
Explain index covering?
What is the drawbacks of normalization?
Explain sybase sql server?