Contact Us

Direct parcel distribution CZ s.r.o.

Customer Case: Direct parcel distribution CZ s.r.o.

 

 

KEY SUMMARY
  • Name: Direct parcel distribution CZ s.r.o. 
  • Industry: Transportation 
  • Technologies/Systems: Windows Server 2012, Windows Server 2016, SQL 2012 Enterprise, SQL 2016 Enterprise. Cluster Mode, High Availability Groups 

 

CHALLENGE 

Challenge 1: Slow Performance and Long Query Times 

  • Reports and dashboards take hours to generate. 
  • Complex queries overload the system, causing timeouts. 
  • Employees waste time waiting for data, delaying decisions. 

 

Challenge 2: Downtime and Poor Reliability 

  • Frequent outages due to poor monitoring or a missing high-availability setup. 
  • Backups are incomplete or untested, leading to risk of data loss. 
  • No/Poor disaster recovery plan in place for critical databases and SQL servers. 

 

Challenge 3: Complex Administration and Inefficient Maintenance 

  • SQL servers were managed manually without transparent processes or automation. 
  • Routine maintenance tasks (patching, index management, backups, monitoring) consumed too much time from the IT staff. 
  • Lack of centralized monitoring meant issues were only discovered once performance dropped or downtime occurred. 

 

 

 

SOLUTION 

Challenge 1: Slow Performance and Long Query Times 

 

Solution 

  • We made SQL Audit with Woodler 
  • Analyzed top resource-consuming queries and redesigned indexes. 
  • Optimized stored procedures and execution plans. 
  • Implemented performance monitoring to identify future bottlenecks. 

Results 

  • Query times reduced by up to 70% in some cases 
  • Reports that took in some cases were reduced from 2-hour runs to under 10 minutes. 

 

Challenge 2: Downtime and Poor Reliability 

 

Solution 

  • Implemented High Availability (AlwaysOn, clustering, failover). 
  • Automated backup verification and disaster recovery testing. 
  • Set up proactive monitoring with 24/7 alerting. 
  • Migrated to up-to-date SQL Server version 

Results 

  • Achieved 99.9% availability. 
  • Recovery time reduced from hours to minutes. 
  • Eliminated unplanned outages that impacted services or revenues 

 

Challenge 3: Complex Administration and Inefficient Maintenance 

 

Solution 

  • Centralized monitoring and alerting across all SQL servers. SMT tool by Woodler. 
  • Automated backups, index rebuilds, and patch management. 
  • Created standardized SOPs and trained the IT team. 
  • Implemented HA/DR plan to protect business continuity. 

Results 

  • The IT team saved resources on routine maintenance. 
  • Reduced risk of errors and vulnerabilities. 
  • Freed IT resources for strategic projects instead of firefighting. 

Key technology/solution: 

  • SMT tool by Woodler 
  • New backup and automated recovery solution based on the default SQL feature for backups that are available in SQL Server 
  • Sign contract for 24/7 3rd-level support and maintenance with Woodler 
  • Regular SQL Audit/Healthchecks managed by Woodler 

 

Customer Quote 

"Thanks to the optimization with Woodler, we got a better and reliable solution for our SQL server. Now we can rely on our reports, which are run in minutes instead of hours. The time we’ve saved allows our teams to make faster business decisions and focus on growth, not waiting for data or taking care of SQL administration and maintenance."