MS SQL Server database as a service

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.