How do you troubleshoot if your tempdb gets filled
- 13 Answers
- 41595 Views
- HCL, I also Faced
- E-Mail Answers
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
How do I open sybase control center?
List different types of sybase index.
Explain about the mainframe connect tools from sybase?
List some of the products of sybase.
What is rollback trigger in a trigger?
How would you replicate col = col + 1 in sybase?
Differentiate between replication server and sql remote?
How do you check database space?
What is trace flag definitions in sybase?
When you change a database option when will it come into effect?
List similarities and differences between oracle & sybase.
How to connect sybase database from python?
Tempdb is full. How would you clear it?
Given a table which contains some rows with duplicate keys, how would you remove the duplicates?
What do you mean by adaptive server enterprise?
