MS SQL Server AlwaysOn high-availability groups – job monitoring and Schwenk
Project duration: 5 months
Brief description
Monitoring processes are set up for the SQL server AlwaysOn high-availability groups used by the customer; these processes monitor cross-database SQL server agent jobs for relevance to the corresponding databases under AlwaysOn and to establish whether the jobs have been manipulated. This ensures that the jobs are implemented redundantly and in the same version in all replicas. Furthermore, modules are implemented to ensure, in the event of a failover that the relevant jobs are activated on the new primary replica and are deactivated on the new secondary replica.
Subject description
The customer operates a three-figure number of MS SQL Server instances in various editions and versions. The hosts are primarily made available on a dedicated VM farm. A wide variety of installations are used, from single instance to multi-instance, AlwaysOn failover cluster instances, and also AlwaysOn high-availability groups.