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.