tempdb filling up issue - but not emptying!

[pauljt]

Has anybody experienced a problem whereby tempdb
space is used up - but after the spids have disconnected,
the space is still not freed up?

and what solution did they find?

sp_spaceused shows on syslogs the space is still allocated.

We believe a known bug is if 'trunc log on chkpt' AND
'checkpoint on recovery' are both seleted, a problem of
this nature can occur.
We have switched off 'checkpoint on recovery' as advised by
Sybase.

We are running ASE 12.0 on Solaris 5.8

Thanks

 

[sybaseguru]

Have you checked master..syslogshold for any long running transaction?

This was a problem in older version of sybase.

Try rebooting the server. This will rebuild tempdb from scratch based on model and will free up the space.

good luck