How do you troubleshoot if your tempdb gets filled
Answer Posted / ajith prabhakaran
lct_admin (0,2) would abort all open transactions, or you
can go for altering the tempdb space. Multiple tempdb's is
a feature which can be implemented to minimize such issues
of tempdb getting full.
Is This Answer Correct ? | 23 Yes | 4 No |
Post New Answer View All Answers
What is the timestamp datatype in sybase?
What sybase central?
Why place tempdb and log on low numbered devices?
How would you lock a table in sybase?
What do you mean by adaptive server enterprise?
How do I move tempdb off of the master device?
What will cause the size of a stored procedure to grow in sybase?
Tempdb is full. How would you clear it?
What is sybase replication server?
Explain index covering?
How would you check the long running transaction?
State some of the products of sybase?
What is asa in sybase?
Differentiate between clustered and non-clustered index.
Is sybase relational database?