How do you troubleshoot if your tempdb gets filled
- 13 Answers
- 41545 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / vineet pal
1. check error log to find the tempdb full.
2. find out the space free in tempdb usin select lct_admin('logsegment_freepages'dbid)
3. dum tran with truncate only if still full than..
4.dump tran with no_log still full than..
5.find process from syslogshold/sysprocesses. inform user about condition ask for killing if he says yes then
6 kill the preocess
if user says no than alter the tempdb
7 you can also use lct_admin('abort',0,2) to kill all suspended trans.
or last on recomendation restart the server
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain about the features of sybase iq?
What is asa in sybase?
What are the important features of sybase?
What are table partitions? How is it different with ase 15.0 version?
What are the vital features of sybase?
What you need to do is issue an ase kill command on the connection then un-suspend the db?
What is my identity burn factor vulnerability right now in sybase?
Are there any alternatives to isql in sybase?
You need to remove duplicate rows from a sybase table. How would you do that?
Explain the features of sybase.
Explain the advantages of data integration suite in sybase.
What is sybase? What are its important features?
What happen when we delete the table using trigger?
How would you list objects in sybase?
Differentiate between replication server and sql remote?
