Perrigo – SQL Monitoring & Capacity Solution
Secure IT by Design.
Trusted When It Matters Most.
Empowering Perrigo with Microsoft-Centric SQL Server Monitoring Solutions
Client Overview
Perrigo Company plc: A global leader in over-the-counter (OTC) health and wellness products headquartered in Dublin, Ireland, with key operations in Allegan, Michigan, USA. Perrigo’s extensive Microsoft SQL Server environment encompasses over 500 instances, demanding robust monitoring to ensure optimal performance and uptime. Their database administration (DBA) team operates from Chicago, USA.
CDW Corporation: A trusted provider of technology solutions, partnered with Cased Dimensions to deliver a cutting-edge, Microsoft-focused monitoring solution tailored to Perrigo’s SQL Server infrastructure.
The Challenge: Scalable, Secure Monitoring for 500 SQL Server Instances
Perrigo faced a critical need for a comprehensive monitoring solution that would align seamlessly with Microsoft best practices while meeting the following key requirements:
- A scalable design capable of supporting over 500 SQL Server instances.
- Seamless integration with existing Microsoft technologies.
- Effective knowledge transfer to upskill Perrigo’s DBA team.
- A phased implementation plan starting with 50 SQL Server instances as an initial test.
The Solution: A Collaborative Microsoft-Centric Approach
Cased Dimensions, in collaboration with CDW, delivered a tailored solution aligned with Microsoft technologies to address Perrigo’s challenges. The approach consisted of the following phases:
- Assessment and Design
- Collaborated closely with Perrigo to define a robust architecture based on Microsoft’s performance and security best practices.
- Documented both business and technical requirements to ensure the monitoring solution was custom-fitted to their SQL Server environment.
- Scalable Implementation
- Designed and sized a globally deployable monitoring solution scalable across 500 SQL Server instances.
- Successfully configured and implemented monitoring for an initial 50 SQL Server instances, validating the design through a pilot project.
- Seamless Microsoft Integration
- Leveraged key Microsoft tools and frameworks to enhance monitoring efficiency, reporting accuracy, and automation capabilities.
- Knowledge Transfer and Upskilling
- Delivered in-depth training for Perrigo’s DBA team, enabling them to manage, troubleshoot, and scale the solution independently.
- Provided comprehensive documentation adhering to Microsoft’s operational standards for ease of future deployment.
- Assessment and Design
Results and Impact
The successful delivery of this project led to significant operational improvements and long-term benefits for Perrigo, including:
- Enhanced Monitoring and Performance
- A scalable monitoring solution fully aligned with Microsoft SQL Server best practices.
- Proactive issue detection and resolution, supporting Perrigo’s global operations with minimal downtime.
- Knowledge Empowerment
- Perrigo’s DBA team was empowered through targeted training, enabling them to independently deploy and manage the remaining 450 SQL Server instances.
- Seamless Technology Integration
- The solution’s tight integration with Microsoft technologies streamlined daily operations, reduced complexity, and allowed for future scalability.
- Client Satisfaction
- Perrigo provided outstanding feedback, highlighting Cased Dimensions’ deep expertise in Microsoft technologies, collaborative approach, and dedication to delivering tangible results.
- Enhanced Monitoring and Performance
Conclusion: Delivering Excellence through Microsoft Best Practices
This case study demonstrates Cased Dimensions’ ability to deliver customised Microsoft-centric solutions for complex global IT environments. By combining technical expertise, seamless integration, and comprehensive support, Cased Dimensions enabled Perrigo to achieve operational excellence and maintain continuous uptime across their extensive SQL Server estate.
The successful collaboration between Cased Dimensions and CDW underscores their shared commitment to leveraging Microsoft technologies for innovative, scalable solutions—ensuring long-term client success and satisfaction.