The multi utility supplier EWII accommodated increased server load with a database optimization
EWII ensured that their business-critical systems could keep up with their growth by getting a Microsoft SQL database optimization
EWII is an energy company, founded in 1868, with headquarters in Kolding, Denmark, where they supply electricity, heat, water, and fiber network. EWII is a future-oriented company that wants to play a major role in the development of new, innovative, and intelligent solutions in the energy sector.
Switching to monthly billing resulted in increased server load
When EWII switched from quarterly billing to monthly billing, they identified a need to optimize their Microsoft SQL solution to have more computing power. EWII's existing SQL solution was unable to keep up with the new increased load, so they could no longer calculate the well over 260,000 monthly bills quickly enough.
SQL optimization gave a big boost in performance
To meet the new demand, EWII contacted Cegal, (then Systemtech), which had been working with Tre-For and now EWII on their critical business infrastructure for many years.
A Cegal database specialist was tasked with recommending a completely new Microsoft database structure, that could cope with the new load that EWII's servers experienced after the switch to monthly billing.
There was a need for a database analysis and a SQL performance optimization with a focus on being able to guarantee high uptime and high computing power.
"We have cooperated with Cegal for several years about e.g Microsoft SQL for one of our business-critical systems. When faced with the challenge of going from quarterly to monthly bills, I knew it would require SQL specialist help and perhaps a re-design of our existing setup.”
Lars Gregersen, IT-konsulent EWII
One of Cegal's database specialists designed a brand new MS Always On Cluster. The technology can ensure companies high database availability both in relation to sudden crashes, but also in connection with e.g., planned IT service.
A huge Microsoft SQL performance optimization
The consultant then went in, and performance optimized the SQL servers as much as possible.
After test-running the new performance-optimized SQL server, EWII saw a huge jump in performance. Where EWII could (only) calculate 11,500 bills per hour with their old solution, with the new solution, they could calculate up to 120,000 bills per hour.
The implementation of the new SQL solution has resulted in EWII experiencing a SQL performance optimization of 943.48%.
"Cegal's architect solved the task completely and with impressive improvements."
Lars Gregersen, IT-Consultant EWII
It is important that the database does not become the bottleneck in your IT setup, both for your business innovation and the increased expectations of employees and customers for data and the use of data.
With a database optimization, you can ensure better performance and, in some cases, postpone the modernization of your hardware.
In addition, a redesign / database modernization project can ensure that you do not end up with the inability to recreate backup data, in the form of corrupt data, or a ransomware attack on the SQL server.
If a weak database is holding back your IT setup and hindering your opportunities for growth and innovation, you can ensure better performance that leaves room for growth, and in some cases postpone the need for modernization of the hardware with a database optimization. It can be both on-prem, hybrid and cloud solutions that we help you with.
