How do you troubleshoot if your tempdb gets filled
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 to compute database fragmentation in sybase?
Why not max out all my columns sybase?
How do I take advantage of table partitioning with bcp in sybase?
How can set the multipal database ?
Is sybase free?
How to pad with leading zeros an int or smallint in sybase?
Explain the difference between numeric and decimal data types in sybase.
What are the catches?
What do you mean by asa in sybase?
How do I choose which tables to partition in sybase?
What is asa in sybase?
How do I start sybase control center in windows?
what is the difference between an ltm and a repagent in sybase?
Differences between clustered and non-clustered in sybase?
How to implement if-then-else in a select clause in sybase?