How do you troubleshoot if your tempdb gets filled
Answer Posted / eshwar
if tempdb is full
1. check the free space of tempdb by using command
1>sp_helpdb tempdb
2>go
it show the size of tempdb and free space
2) check whether logshold transaction is going on
1> select * from syslogshold
2>go
you see the long hold transaction if their is any long hold transaction
see the user and time and inform to the user by raising ticket to him
as per his response we will kill the long hold transaction command
1> kill sid
2>go
or else we will try to increase the size of tempdb
by using command
1>alter database tempdb on devicename='size',log on logdevice='size'
2>go
if this command is not working. we will clear the tempdb by using this dump command
1>dump tran tempdb to '/path'
2> go
or
1>dump tran with tranket_only
2>go
or
1>dump tran with no_log
2>go
if else it is also not working. We will clear the tempdb by using command
1>select lct_admin('abort',0,2)
2>go
this command will clear all transaction and longhold transaction in tempdb
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
When should I execute an sp_recompile in sybase?
Explain update statistics.
Explain 'forcing an index' concept.
There is no space in file system and you need to take a back up. What will you do?
Explanation about replication server software?
What do you mean by exception log in replication?
What do you mean by adaptive server enterprise?
State some of the products of sybase?
When are stored procedures compiled in sybase?
What is the default size of master database in sybase?
Is sybase relational database?
How do I configure identities in sybase?
Explain about the features of sybase iq?
What will cause the size of a stored procedure to grow in sybase?
Why not max out all my columns sybase?