Skip to Content
1
Jan 12 at 04:51 AM

Related to log cache at sybase

396 Views Last edit Jan 12 at 04:52 AM 2 rev

We have a warm standby replication between two sybase ase databases, to tune performance of both sybase ase and sybase replication, we added a log cache for active database, on the side of this database, we noted it became more agile when we execute storedprocedure that deal with huge tables, i.e this procedure was taken about 2 min to finish, after adding the log cache it takes now about 50 sec, and in the sysmon report , in replication agent section, we found that time needed to scan log was decreaeed comparing to the time needed when we were exec the same procedure before adding the log cache, but we also noted the latency between two databases increased , is there any related issue between them ?

We get latency by calculate the difference between origin time and commited time in the rs_lastcommit table at standby database

Any hint will be useful

Regards