Case study

Monitoring multiple SQL Server estates with a single solution

Customer

One of the largest providers of consumer finance in the US, focused on the digital lending of loans and mortgages

Challenge

Ensure availability of their estate as they prepared to launch a new product

Solution

A single monitoring solution to cover production, development, and test environments

Results

Successful implementation of SQL Monitor in time for the new product launch

The customer

The US’s second largest non-bank provider of direct-to-consumer finance, focused on digital lending of loans and mortgage products. Founded in 2010, the company has an annual revenue of nearly $2bn and a large estate of 120 SQL Servers.

120 SQL Servers 55% increase in customers $1.9 bn annual revenue

The challenge

The company had previously installed some SQL Server monitoring tools to manage a few critical servers on their estate, split between a couple of vendors.

However, the imminent launch of a new product, which would see an expected 55% increase in new applicants, meant it became critical to implement a robust monitoring tool to cover the whole estate, including non-production servers.

They needed to establish product requirements, identify vendors, and arrange implementation within a two-month timescale.

The solution

The priorities for a solution were as follows:

The DBA Manager wanted to ensure availability and compliance. It was key that critical servers could cope with the increase in traffic following the product launch, but also that the sensitive financial information was kept secure.

The SVP of Mortgage Technology wanted to ensure applicants had a smooth experience when interacting with the new product, as well as making sure the development team could work closely with the DBA team to respond to tickets and made critical changes.

The Chief Architect needed to have a holistic estate view to see how both the production and non-production environments were coping with demand, and gain the ability to identify areas to improve efficiency.

After trialling two vendors, they chose Redgate’s SQL Monitor as it was able to provide full estate coverage at scale, within budget, and in time for their new product launch.

This ensured the critical production servers could be closely monitored at launch, but also non-production environments were kept available and secure to support the ongoing development work.

The results

SQL Server monitoring consolidated to a single provider.

Full implementation of SQL Monitor across entire SQL Server estate in under two months.

Monitoring ensured the DBA team was prepared for the new product launch.

SQL Monitor helped the communication flow between the DBA and Development teams, helping them make improvements without impacting performance.

Report

The State of SQL Server Monitoring

Redgate's annual State of SQL Server Monitoring survey provides new insights into how the world of SQL Server monitoring is adjusting and adapting to emerging challenges.

Get the report

Whitepaper

How SQL Server monitoring benefits your whole organization

In this guide, we take you through the ways a robust SQL Server monitoring solution has a positive impact across your organization, from the development teams to IT management, and from finance to the C-suite.

Read the whitepaper

We're here to help 01223437921

Whether you want more details about SQL Monitor, 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'.