Case study

Supporting government efficiency through monitoring

Customer

Government authority located on the east coast of the United States

Challenge

Overcome government regulations to implement complete estate monitoring

Solution

A compliant monitoring tool that fits into their tech stack

Results

Successful implementation of SQL Monitor to monitor the whole estate

The customer

A county located on the east coast of the United States, within the New York metropolitan area and with a population of over 600,000. They have over 1,000 employees and an increasing SQL Server estate that manages the data for county operations.

50+ SQL servers 1000+ employees 600,000+ population

The challenge

A government authority has a constant requirement to ensure data is managed securely, and availability allows citizens and employees to access the right information when they need it.

As this county’s databases grew, they needed to implement a scalable solution that would allow them to keep track of their expanding estate, react to problems, and fix them in a timely manner.

They instigated a project to implement a monitoring solution within 6 months to cover all of their SQL Servers. The supplier needed to meet government vendor requirements and meet their strict annual budget allowances.

The solution

As an existing user of SQL Compare, the county engaged Redgate to provide a proof-of-concept (POC) for monitoring, alongside four other vendors, as required by state regulations. They also needed to go via a state-approved reseller, which Redgate already had in place.

Following the POC, Redgate helped the county set up monitoring on five critical servers and enrolled their DBA team onto our Redgate University course so they could immediately see the benefit SQL Monitor provides.

The Director of IT was also able to see the ways SQL Monitor could be integrated into their wider tech stack, therefore becoming an integral part of their DevOps set-up.

SQL Monitor was implemented and successfully monitoring all of their servers, two months ahead of schedule.

The results

Full SQL Server monitoring in place within four months.

Integrated DevOps processes in place, with SQL Compare and SQL Change Automation linked to SQL Monitor to provide detailed deployment results.

DBA team able to realize the full value of SQL Monitor through tailored online training.

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'.