A healthcare network's Sybase ASE platform had no proactive monitoring and was firefighting P1 incidents monthly. MDA-based alerting and a 3-tier escalation model turned reactive support into a stable operation.
The client's patient records and scheduling platform, running on Sybase ASE, was generating an average of 11 P1-level incidents per month — each one discovered only after clinical staff reported the system was down or unresponsive.
There was no monitoring layer watching tempdb pressure, lock contention, or session activity — the first sign of a problem was always a user-reported outage, never an internal alert.
With no tiered support structure, every incident — from a routine lock wait to a full instance outage — landed directly on the one senior DBA available, creating both burnout risk and inconsistent response times.
The goal was never to respond to incidents faster — it was to prevent most of them from reaching P1 severity at all.
Reviewed six months of incident history against captured MDA metrics to identify which categories of P1 — tempdb exhaustion, lock contention, replication breaks — were recurring and therefore preventable.
Deployed monTempdbActivity-based alerting at 70%, 85%, and 95% tempdb space watermarks, giving the team a warning window before space exhaustion could cascade into an outage.
Added monProcessActivity and monDeadlock-based monitoring tuned to the platform's actual clinical-hours load profile, catching blocking chains before they degraded into a user-visible outage.
Introduced a structured L1/L2/L3 escalation path with documented runbooks for known issue categories, so routine incidents were resolved at L1 and only genuine complexity reached senior engineers.
Introduced weekly ASE health reports covering tempdb trends, cache hit ratios, and slow-query patterns, turning what had been silent degradation into a visible, trackable trend line.
"We went from bracing for the next outage every week to genuinely forgetting the database was even there — which, for a system clinicians depend on all day, is exactly what we wanted." — OptiSol Sybase Production Support Lead
Let's Talk
Tell us what you are running today and where you need expert support.
"*" indicates required fields
Global Presence
Five global locations. One connected engineering team.
North America
Chennai · Coimbatore
Client services
Regional operations
Client services
