Case studies

Direct Parcel Distribution CZ, in cooperation with Woodler, resolved the slow performance, instability, and complex administration of their SQL servers. Optimization and automation reduced report generation time by 70% and achieved 99.9% system availability.

Woodler helped Eprin resolve critical database stability and responsiveness issues by optimizing SQL queries, redesigning indexes, and fixing server licensing constraints, ultimately unlocking 100% of CPU capacity and improving overall system performance.

The client reported a massive spike in transaction wait times, specifically the HADR_SYNC_COMMIT wait type. Preliminary observations suggested that transactions on the Primary node were stalling while waiting for hardening confirmations from the Secondary Replica.

The client operated a large multitenant ERP platform with more than 1,300 separate databases on a single SQL Server instance. During morning peak hours, the system experienced unpredictable response time spikes and maximum CPU utilization, while standard monitoring and traditional query or index tuning methods provided only limited improvements.

During proactive infrastructure monitoring, our database engineering team detected a critical bottleneck on the SQL Server instances of two enterprise clients. The dominant wait type across both environments was identified as a highly unusual OS-level state: PREEMPTIVE_OS_QUERYREGISTRY. This case study details how our team isolated the root cause, correlated engine telemetry, collaborated with Microsoft Support, and deployed a specific, multi-layered mitigation strategy to restore optimal system throughput and prevent worker thread starvation.