Case study

Keeping pace with a shifting tech landscape

Customer

The world’s leading premium automobile and motorcycle manufacturer, financier, and dealership

Challenge

Ensure the server estate copes with the demands of the numerous applications being developed by the business

Solution

Proactive estate-wide monitoring, where development teams have direct access to the monitoring tool

Results

Dramatic reduction in tickets submitted to the operations team, and the server estate is now better able to scale

The customer

The world’s leading premium automobile and motorcycle manufacturer, financier, and dealership. Headquartered in Germany, with over 130,000 employees distributed globally, 2018 revenues amounted to nearly €97.5 billion.

The challenge

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.

The solution

The solution was to move to a proactive estate-wide monitoring approach, that could act as a planning aid to minimize downtime and service degradation. This involved being able to analyze and set baselines for each territory’s estate.

Once this was established, the developers who were most frequently deploying applications to the estate were given direct access to the monitoring tool, in order to observe the impact of their code.

The results

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 Executive Brief:
Compliant Database DevOps

(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"

Get the IDC Executive Brief

Case study

Meeting customer demands for software delivery

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.

Case study

Delivering results with an increasingly distributed workforce

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.

Case study

KEPRO: Ensuring HIPAA compliance

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.

We're here to help 01223437921

Whether you want more details about SQL Provision, a demo, or to know about best practice – get in touch.

The industry standard tools for 20 years

Redgate has specialized in database software for 20 years. Our products are used by 804,000 IT professionals, in more than 100,000 companies.

World-class support

Redgate offers comprehensive documentation and a friendly, helpful support team. An average 87% of customers rate our support 'Excellent'.