This is one of 4622 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 database as a service

Project duration: 9 months

Brief description

The customer wishes to offer SQL Server databases as a service, as part of its portfolio of services and in order to offer customers a more cost-effective alternative to a full SQL Server instance for smaller applications. In the course of the project, the infrastructure is prepared for operation of the instance. This involves two SQL Server instances on two hosts. A high-availability solution is implemented using AlwaysOn for the functional databases. Other focuses include resource allocation for the individual databases by means of Resource Governor. A monitoring system developed specifically for the individual requirements of the service monitors the central performance indicators, such as CPU utilization, memory use and data file utilization. These parameters are collected in a database that was developed specifically for this purpose on a separate instance, and the parameters are then made available to the central infrastructure monitoring via test algorithms.

Supplement

To minimize operating costs, routines are also developed for fully automated provision of new databases and to integrate these into the AlwaysOn group.

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 period27.06.2016 - 31.03.2017

Have we sparked your interest?

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

Marcus Rödiger

Head of Consumer Goods & Retail

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.