On Apr 9, 6:18*am, sco...@amnet.net.au wrote:
> Hi all
>
> If this is impossible, I will be gobsmacked.
>
> Can someone *please* tell me how to disable transaction logging in
> tempdb? We have absolutely zero interest in point in time recovery on
> this DB, and all the transaction log is doing is causing us
> performance and space issues.
>
completely disabling transaction logging is not possible in ASE.
However sizing tempdb appropriately reduces the overhead
cosiderably.You also have option to create "user tempdb" to
distribute tempdb load across databases.If you dont care about point
in time recovery, to reduce tempdb log size you can execute dump
transaction process with no_log in loop which will truncate log as
often as *possible* .

-HTH
Manish Negandhi
[TeamSybase Intern]