I have an issue where my log file currently at 40G fills up within 15-20 minutes when running any stored procs. This is a recent problem and i am not aware of any changes to the database.
The database itself is 90GB running on Sybase 12.5.3 The stored procs do nothing more than join selects which in turn dump to temp tables and do additional joins with the temp tables to return output.
I turned on sp_dboption 'dbname' "trunc log on chkpt", true
How does sybase handle checkpoints? If i insert checkpoints throughout my proc code will it provide a work around?
If anyone else has had any similar issues please let me know if you have any suggestions.
Thanks!
The database itself is 90GB running on Sybase 12.5.3 The stored procs do nothing more than join selects which in turn dump to temp tables and do additional joins with the temp tables to return output.
I turned on sp_dboption 'dbname' "trunc log on chkpt", true
How does sybase handle checkpoints? If i insert checkpoints throughout my proc code will it provide a work around?
If anyone else has had any similar issues please let me know if you have any suggestions.
Thanks!