Bournemouth & Christchurch and Poole NHS Trusts wanted to modernise their SQL Server database environments to future proof the performance of its critical applications, to best serve the Hospital Trusts. It had sprawling legacy SQL Server environments running old versions of SQL on numerous dedicated and shared servers across multiple sites. The cost to maintain, manage and license the environment was becoming overly time consuming and expensive.
Northdoor undertook a workshop with the Trusts stakeholders to understand the database environment requirements which included evaluating performance, workload trends, back-ups, DR, licensing, security, consolidation, capacity flexibility, migrations to newer versions of SQL. Northdoor then offered SQL server consulting and audited the existing environments of both Trusts and ran performance monitoring software to capture existing workload trends. Once that information had been obtained, Northdoor were able to generate appropriate environment and associated licensing designs based on those requirements.