For any complicated (typically credit card) processing environment, authorization has a key
role. This means that once the card is placed at a merchant outlet, it should get validated and
authorized for the transaction to occur smoothly, which in turn is referred as STIP.
In other words, a situation arises when the card validation procedure faces a bottleneck and
thus results in requests pouring in but not able to process in proper time. In such a scenario
where the back end is handled by MS SQL Server, the respective team immediately needs to
be engaged to avoid any larger impact as it has been observed closely.
So, a quick isolation procedure involves the understanding of the bottleneck promptly. As
understandable, STIP forms the lifeline for a card processing system and most likely an
organization like Scalability with adequate exposure to handling of large databases understand
the critical dependency for it. Hence, the first check needs to be done at the database level
where resources could be a constraint in terms of CPU, Memory, Blocking and any other
related aspect. It has also been observed that a slow wait type can lead to a delay in a commit
and thus a longer wait time for STIP authorization. At Scalability, the impact of a STIP has been
understood over time and thus segregation is usually rather quick. Such is the importance and
sensitivity of this that unless the action is quick and able enough, there could be a cascading
impact. So, the moment the bottleneck is ascertained teams come together to address the
issue to allow STIP to return to normalcy.
In fact, to conclude though the point remains that a trained DBA team understands the value
of a quick isolation and forms the heart of a complex database support system. Thus, the
importance of issue isolation is high and unquestionably the assurance from Scalability thus
runs high enough to be of respect and consistent enough.
STIP Issues & Database Impact
- April 05, 2024 | Samrat Sengupta, Vertical Head - DBA & Infra
Author
Samrat SenguptaSamrat heads the Vertical for the DBA services for Scalability as an organisation and is part of the decision making for determining the roadmap in the long run. With 25+ years of experience in IT, his core competence lies in Database functionality understanding & adopting new technologies. He is also aligned in grooming the relevant team, contributing technically and thereby assessing the path forward.