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
Explanation about replication server software?
Explain locking. List its types.
List the types of locking?
Explain the advantages of sybase iq.
What do you mean by sybase iq?
Explain table partitioning in sybase.
How do I choose which tables to partition in sybase?
What will cause the size of a stored procedure to grow in sybase?
What are the vital features of sybase?
What is the timestamp datatype in sybase?
Explain the structure of adaptive server enterprise?
Explain update statistics.
What are the advantages that you can get from mainframe connect in sybase?
Is sybase sql?
Alternative to row at a time processing in sybase?