With a workforce exceeding 37,000 employees, the Hungarian Bank plays a significant role in the finance sector.
In this case study, we explore how a challenge with MSSQL indexing strategy led to application failures, prompting a thorough investigation and solution implementation to ensure optimal performance.
A critical problem emerged within the Hungarian Bank's application stemming from an erroneous MSSQL indexing approach. The flawed indexing strategy had triggered fragmentation within vital tables, leading to diminished performance and recurrent application breakdowns.
Acknowledging the gravity of the situation, the team initiated a week-long investigation to pinpoint and address the underlying cause of the issue.
One of the primary challenges faced during the investigation was the necessity to perform
index rebuilds at night to minimize disruptions to daily operations.
This posed logistical challenges and added pressure to swiftly identify and implement a solution to prevent further application failures.
Through meticulous analysis, the team identified that a critical table's index was heavily fragmented, contributing to the application failures. By rebuilding the index, the immediate issue was resolved. However, further investigation revealed that the indexing strategy itself was flawed, as it did not adequately consider the size of the table. To address this underlying issue, the team modified the indexing strategy to ensure optimal performance.
Additionally, previously overlooked important indices were identified and rebuilt to prevent future incidents. With these changes implemented, the issue was successfully resolved, ensuring the stability and reliability of the Hungarian Bank's application for the long term.
