How do you troubleshoot if your tempdb gets filled
- 13 Answers
- 41597 Views
- HCL, I also Faced
- E-Mail Answers
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
List the merits of index covering.
What is sybase used for?
Differentiate between clustered and non-clustered index.
You want to delete a table in sybase. How would you do it?
How do I configure identities in sybase?
Explain the advantages of sybase iq.
How to find the time taken for rollback of the processed?
Explain bind cache?
How would you improve throughput in sybase?
What is table partitioning in sybase?
How do the blocker processes exist internally in sybase?
What is ceiling()?
How do I pipe the output of isql to a file in sybase?
What will cause the size of a stored procedure to grow in sybase?
What are the best monitoring tools for the sybase database?
