Scalability Engineers

Issue: End of month processing generating Replication latency of 6 hours.

It is critical to put primary and reporting database servers in sync. As reports needs to be generated on time daily basis. Latency was causing missing SLA by reporting team.
We methodically addressed it using below steps


► Collect server vitals mainly cpu, memory, disk, network, wait stats, blocking issues.
► Analyze server vitals by our experts.
► Document our expert recommendation to fix issues.
► Create implementation plan.
► Execute it.

Solution
► Increase network bandwidth.
► Make redo process multithreaded.
► Removed high command generating table.