Interested to Buy Any Domain ? << Click Here >> for more details...
How do you troubleshoot if your tempdb gets filled
- 13 Answers
- 44259 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
Explain the advantages of sybase iq.
Is sybase owned by sap?
Why place tempdb and log on low numbered devices?
What is open server in sybase?
Explain autosys. Why do you need it.
Explain coalesce. What is the equivalent of oracle/db2 coalesce function in sybase?
How do I find the oldest open transaction in sybase?
How to check if sybase database is up and running?
What is the default table size in sybase?
Explain coalesce.
What is trace flag definitions in sybase?
What is the role of replication server in sybase?
How does partition assignment relate to transactions in sybase?
Explain locking?
What causes re-resolution of a stored procedure in sybase?
