As in many other businesses, the operations teams in this vast motor group were under pressure to deliver more with less resource. As the business had grown, what was originally an Oracle-dominated technical estate began to see more developers turning to SQL Server.
Ultimately, an ops team of 12 people were responsible for ensuring that the server estate (with significant, multi-terabyte loads) was able to cope with the demands of the numerous applications being developed by the business. At the same time, the team was being asked to ensure that the environment was equipped for ever-evolving security challenges. This meant reviewing and rebalancing how much time they were spending on maintaining operational performance against time invested in development. It was a classic dilemma: deliver a consistent, uniform environment with defenses that ensure maximum uptime.
There are several major benefits to the new solution, all of which help to minimize performance downtime and degradation as well as freeing up time for the operational team.
There has been a major change in how the development and operational teams work together. Internal developers are able to see the impact their code changes are likely to have, before they hit production, avoiding negative customer impact.
This has led to a dramatic reduction in the volume of tickets submitted to the operations team asking them to identify the root cause of issues. Developers are more empowered to pinpoint the cause and consequence, and operations are used more as a point of escalation, giving people the power to solve their own problems.
Freed up from reactive fire-fighting, the team are able to focus their time on predictive analysis, ensuring the entire estate is optimized for future growth. As apps increase in capacity and transaction volume, it is easy to see which servers are coping with the demands and are fit to scale.
This greater level of insight means the team can see which servers are coping well and where services need to be moved to different machines.
(IDC #EUR145261019 June 2019)
Download this free IDC Executive Brief for an invaluable understanding of the critical role database teams play in driving a leaner and faster development cycle.
"The ability to accelerate digital innovation at volume and pace will be the most critical new benchmark for organizations competing in the digital economy"
A European national airline increased the speed and reliability of their deployments, freeing up development time and adding a visible version history for their database to aid audit and compliance.
A FTSE 100 wealth management business with application development teams distributed across India and the UK reduced the time taken for deployments from twelve hours to two, with fewer post-deployment errors.
Since adopting SQL Provision, KEPRO, a leading healthcare organization, have been able to get a new off-shore development team running and compliant, save 15-20 hours a week in provisioning processes, and reclaim terabytes of disk space.