How do you troubleshoot if your tempdb gets filled
- 13 Answers
- 40580 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
How do you use workspace in sybase?
What is open server in sybase?
Explain the advantages of data integration suite in sybase.
How to check sybase database status in linux?
Explain sybase sql server?
What do you mean by mainframe connect tool in sybase?
What will you do if a replication thread goes down?
How to clear tempdb when the tempdb gets filled in sybase?
Is sybase owned by sap?
What are the different types of (all page) locks in sybase?
What is the command for quitting from sybase?
You need to manipulate varbinary columns in sybase. How would you do that?
What is sybase infomaker?
What is coalesce in sybase?
How to fix a munged log in sybase?
