HEPiX Spring 2025 Workshop

Managing Microsoft SQL Infrastrucuture at CERN

Not scheduled

15m

Hotel De La Paix

Miscellaneous Miscellaneous

Speaker

Ricardo Martins Goncalves

Description

For its operations, CERN depends on an extensive range of applications, achievable only through the use of diverse technologies, including more than one relational database management system (RDBMS). This presentation provides an overview of CERN’s Microsoft SQL Server (MSSQL) infrastructure, highlighting how we manage servers and design solutions for large-scale databases with different compatibilities and criticality. We will explore the advantages and challenges of using MSSQL and how we provide high availability for critical databases, tailored solutions for applications, and different environments for production and testing. Furthermore, we will discuss our backup infrastructure and data integrity tests to ensure disaster recovery.