How having AimBetter saved this Pharma company’s CIO dilemma of whether to keep the CDC mechanism, which is critical for regulatory compliance.
A pharmaceutical company with stringent regulatory policies experienced a critical issue when a disk ran out of space during the night, leading to a system outage by morning.
This company relies heavily on Change Data Capture (CDC) to ensure data integrity and for analytical purposes, making uninterrupted operations crucial. The IT Manager, who had just implemented AimBetter to enhance his ability to manage such a complex and sensitive system, initially suspected that the CDC process was the main culprit for the disk space issue.
AimBetter allowed him to review the database activities leading up to the event and discover who was really responsible for this undesired situation.
Upon investigation, the IT Manager identified a significant space decrease in the disk’s time and that this had happened some days before, too.
Checking which queries were running during the disk clogging time, he could detect that an index rebuild, part of a routine maintenance job by the database team, had caused log inflation. This process temporarily consumed much of the disk space, which would not have been problematic under normal conditions. However, the disk space was lower than usual on the day of the event, and the log inflation exhausted the remaining space. The CDC process, which depends on available log space, was disrupted, leading to system downtime.
Identifying the index rebuild as the root cause shifted the focus to adjusting the maintenance process and recommending an increase in disk space to prevent future occurrences. This insight was critical, as it not only resolved the immediate issue but also provided a preventive strategy to maintain system stability in the future.
If you want to learn more about how Aimbetter can enhance your IT management by preventing disruptions and speeding up recovery from unexpected events, please get in touch with us today!
