Case Study: Leading US home‑healthcare technology solution provider eliminates timeout bottlenecks and restores reliable EVV calls with Apriorit

Leading Technology Solution Provider Company - Customer Case Study

Leading Technology Solution Provider Company, a US home-healthcare technology provider handling thousands of Electronic Visit Verification (EVV) calls per hour and up to 40,000 calls daily, faced random service timeouts across its VoIP, database and web servers. After six months of unsuccessful internal troubleshooting, they engaged Apriorit to perform remote production analysis using SQL Server Profiler and real-time performance monitoring to pinpoint the root cause without disrupting operations.

Apriorit isolated the issue to MS SQL query execution plans affected by parameter sniffing, identified three problematic queries, and recommended additional indexes plus code refactoring. The optimizations cut reads on the investigated queries from about 30,000 to 1,000, eliminated roughly 80% of timeouts after the first two index changes, and fully resolved the remaining timeout incidents after the third query fix; Apriorit continues system monitoring under a 3-month warranty while planning further scaling improvements.