Composites Manufacturer – SQL Server Estate Consolidation of over 500 licensed SQL instances across 3 continents.

The Client

Global Advanced Composites Manufacturer – SQL Server Estate Consolidation or over 500 licensed SQL instances across 3 continents.

The Problem

This global leader in the production of carbon fibre and honeycomb manufacturing for the commercial aerospace industry, has a SQL Server Estate spanning 3 continents with over 500 licensed SQL Server instances, there was no overall view of the databases, applications or their owners, and licensing was costing in excess of a seven-figures. The organisation wanted to reduce the licensing costs, improve system management, and better control access to production environments.

What We Did

This project has been carried out in three phases. In the first phase we carried out a full review of all their SQL Server Estate, identified all their applications and their owners. We then planned the migrations with the application owner’s and infrastructure teams. The second phase was the actual consolidation work, we migrated several hundred databases into consolidated server farms. In the third phase we carried out security audits of all the SQL instances.

We now provide ongoing SQL Server Support and monitoring the consolidated instances daily.

The Benefits

Over the course of the project the number of licenses needed has almost halved. This has reduced the licensing cost by over $1,000,000 per annum. The systems are easier to managed, secure and access controls are now in place for all production environments.