Customer Case: EPRIN s. r.o.
KEY SUMMARY
- Name: Eprin
- Industry: Automation, digitalization and robotics
- Technologies/Systems: .NET/Microsoft SQL Server/Siemens/Fanuc
CHALLENGE
Challenge 1: Stability
- We struggled to keep the system with stable performance over the years (when our tables grew in size).
Challenge 2: Responsiveness
- Database responsiveness was visibly slow.
Challenge 3: Performance / Overload
- Server was reporting insufficient resources during high demanding intervals.
SOLUTION
Challenge 1: Stability
Solution
- Woodler identified root cause queries and proposed new index designs which we have review and implemented. Woodler also conducted a workshop on indexing for our developers.
Results
- Core application queries performance was improved significantly because SQL Server was able to retrieve only the data requested by the database query.
Challenge 2: Responsiveness
Solution
- Woodler identified design flaws within our queries and suggested different approach to write queries SQL Server can translate and execute more efficiently.
Results
- Redesigned queries are now finishing in milliseconds instead of original few seconds, therefore greatly improving the overall database responsiveness.
Challenge 3: Performance / Overload
Solution
- Woodler reviewed the entire hosting environment, from hardware configuration to SQL server settings, and helped us optimize the whole solution. Most importantly, Woodler identified SQL Server licensing constrain which was limiting us to use only 50% of our CPU capacity. preventing us from fully utilizing the underlying hardware.
Results
- Reconfiguration of whole server enabled SQL Server to start using 100% of its CPU resources, greatly reducing any CPU bottlenecks we’ve experienced during peak traffic. The server is now utilizing all its resources equally and even has spare performance capacity despite the growing number of users.
Key technology/solution:
- SQL Server 2022 / .NET
Customer Quote:
"We approached Woodler for help managing a web database system that had grown significantly over many years of development, and we were struggling to handle its scale efficiently. They delivered everything we had hoped for and more, not only identifying the issues but also guiding our developers on how to avoid them in the future and strengthen their database skills."
Bc. Jiří Čermák Lukš
Chief Technology Officer
