How to Keep a Production Database Change From Blocking Customer Requests

A migration can hold locks or compete for I/O long enough to slow or block application requests.

Checks to make

Inspect the operation’s lock behavior and expected duration on representative data, monitor database waits during execution, and use bounded batches where possible. Schedule higher-risk changes appropriately and define a stop and recovery plan before running them.

When to get help

Database and DevOps engineering can review migration impact and execution strategy. Informatix Systems can assess the symptoms, evidence, and next steps. Contact Informatix Systems to discuss this issue.