How do you troubleshoot if your tempdb gets filled
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
What is sybase replication server?
Explain the advantages of sybase iq.
Explain coalesce.
What is the default size of master database in sybase?
List some of the products of sybase.
What you need to do is issue an ase kill command on the connection then un-suspend the db?
Compare in and exists?
How do I pipe the output of isql to a file in sybase?
Is sybase a database? Explain.
What are the catches?
Explain about the features of sybase iq?
Explain relationship between jdbc and sybase.
How to compute database fragmentation in sybase?
How to manually drop a table in sybase?
Compare join and subquery in performance?