Displaying difference between revision 2 and 1 of Wiki page:Space available in the log segment has fallen critically low in database 'tempdb'
 
Please wait, loading revisions...
display as  
!!Symptom No Sybase connection possible, the following type of errors appear in the [Sybase error log|WIKIPAGE:5378]: {{{00:00000:00022:2008/09/03 08:29:23.60 server Space available in the log segment has fallen critically low in database 'tempdb'. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available. 00:00000:00017:2008/09/03 08:29:23.67 server Error: 2812, Severity: 16, State: 5 00:00000:00017:2008/09/03 08:29:23.69 server Stored procedure 'sp_thresholdaction' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).}}} !!Solution A reboot of the Sybase server will usually clean the tempdb. If this happens frequently, we recommend to increase the size of the tempdb. Start ([isql|WIKIPAGE:2910]) and run the following command: {{{1> alter database tempdb on default = 10 2> go}}} Furthermore, make sure you run "Perform Manager Maintenance" from the desktop's Admin menu frequently. Depending on overall activity, weekly or monthly at least.