This is one of 4124 IT projects that we have successfully completed with our customers.

How can we support you?

Weißes Quadrat mit umrandeten Seiten rechts oben

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.

Overview

Project period04.10.2016 - 28.02.2017

Have we sparked your interest?

Marcus Rödiger, ein Mann mit braunen Haaren und Brille

Marcus Rödiger

Retail sector manager

Jetzt Kontakt aufnehmen

Zum Umgang mit den hier erhobenen Daten informieren wir in unserer Datenschutzerklärung.

Contact now

We provide information on the handling of the data collected here in our privacy policy.

Download file

We provide information on the handling of the data collected here in our privacy policy.