How do you troubleshoot if your tempdb gets filled
- 13 Answers
- 41590 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / kk07
If your tempdb gets full you can do one of following:
you can expand your tempdb or you can use
select lct_admin(0,2)
go
It will abort all open transactions.But be sure the task by
confirming with the concern users.
Restarting the server is not recommanded.
| Is This Answer Correct ? | 16 Yes | 8 No |
Post New Answer View All Answers
How do I set ts role in order to run certain dbccs?
Can I run any transact-sql command on a partitioned table in sybase?
Explain the advantages of sybase iq.
Can you create your own sps for system wise?
What do you mean by sybase iq?
Explain open server?
How to check sybase database status in linux?
Explain update statistics.
What are the vital features of sybase?
How do the blocker processes exist internally in sybase?
How do I start sybase control center in windows?
Who owns sybase?
How would you lock a table in sybase? What text command will you use for it?
What causes re-resolution of a stored procedure in sybase?
How to connect sybase database from python?
