How do you troubleshoot if your tempdb gets filled
- 13 Answers
- 41557 Views
- HCL, I also Faced
- E-Mail Answers
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 procedure cache and data cache in sybase?
How would you fix a munged log in sybase ?
What is the default table size in sybase?
A single operation is failing to escalate?
How do I create a database in sybase central?
How does sybase replication work?
How can you change to get the decimal separator as comma instead of the decimal point (.)?
How can I improve throughput in sybase?
What are the important features of sybase?
What is sybase replication server?
What are the catches?
How do I turn off marked suspect on my database in sybase?
What is the role of replication server in sybase?
Explain sybase sql server?
What causes re-resolution of a stored procedure in sybase?
