how/when does syslogs get cleaned? who's filling syslogs?

133 Views

--- SYBASE VERSION ---

Adaptive Server Enterprise/15.7.0/EBF 22639 SMP SP52 /P/Sun_svr4/OS 5.10/ase157sp5x/3293/64-bit/FBO/Wed May 21 02:49:14 2014

--- END ---

Hi community,

I'd like to know how and when does the syslogs get 'flushed' one a transaction is commited and the data are written data data physical disk?

I'd like to also know if there's way to know how long this flush lasts?

Why?

Let's imagine I have an update on a huge table taking 45 minutes then it's followed by other DML statement. This batch of operations generates a LOG SUSPEND therefore we need to increase the log.

If I execute individually those statement, the transaction logs is OK

Therefore my assumption is the time the syslogs is not flushed fast enough and other statement fills it.

Therefore I'd like to understand its flushing mechanism and if there are ways to improve it.

Moreover, is there a way to know the transactions filling it? I'd just be interested by transaction ID and the size used.

Thanks

Simon