How do you troubleshoot if your tempdb gets filled
Answer Posted / aditya
If the transaction log of tempdb is full then you call
login through sa and type following command.
> dump tran tempdb with trancate_only
> go
If the database is full then you can increase the size of
the database on a free device.
> alter database tempdb on device_name = size
> go
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
You want to delete a table in sybase. How would you do it?
What is my identity burn factor vulnerability right now in sybase?
How can you change to get the decimal separator as comma instead of the decimal point (.)?
What do you mean by sybase iq?
How would you configure burn factor in sybase?
Must I use multiple devices to take advantage of partitions in sybase?
How can I improve throughput in sybase?
What is sybase infomaker?
What is a natural key in sybase?
When should I execute an sp_recompile in sybase?
What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and in real time when we go to truncate the log?
What is procedure cache and data cache in sybase?
How to check if sybase database is up and running?
What mandatory options are required for bcp command utility?
How to check sybase database status in linux?