Industry: Media and Publishing
Headquarters: Kansas, USA
The Customer is a leading provider of advanced, cross-media publishing and communication services in industries ranging from residential housing, book publishing to cancer care. With combined expertise in content generation, real-time data integration and business process management, the Customer was stretching its IT infrastructure to deliver valuable, industry-specific solutions.
Performance issues stemmed from using an outdated version of Microsoft® SQL Server® on older NetApp® hardware. A hardware refresh to newer, high-performance VBlock hardware was the ideal opportunity to upgrade their database software, as well. However, the customer lacked the internal resources needed to successfully complete such a sizable upgrade project and turned to mLogica to review, plan and execute these tasks.
Modernizing a Microsoft SQL Server 2008 R2 environment to SQL Server 2016 R2 required extensive architecture planning. The hardware refresh from NetApp to VBlock storage demanded further guidance to implement the right backup strategy for the SQL Server instances. mLogica divided the task into three stages: Discovery, Analysis and Implementation.
The following was identified in the Discovery Stage:
Analysis of the Customer’s SQL Server environment uncovered the following details:
The MLGOICA team created recommendations for the Customer’s existing SQL Server architecture and devised an implementation plan with the following:
Modernizing the Customer’s database boosted performance and enhanced overall functionality in a safe and secure environment. By upgrading to SQL Server 2016 and performing a hardware refresh from NetApp to VBlock storage, the Customer was able to deliver timely, valuable, industry-specific solutions without taxing IT resources – a real game-changer for the IT team and corporate leadership.