Monitoring Microsoft SQL Databases Hosted on Cloud

Previously, we elaborately discussed about the wide variety of internal metrics that the eG agent collects from the Microsoft SQL Database server hosted on-premises, and how these metrics impact the internal health of the server. In this modern era where cloud computing plays a major role, most administrators are inclined towards databases offered by cloud service providers rather than investing on databases that are hosted on-premises. The database offered by cloud service providers is termed as a Managed Cloud Database Instance. These managed databases simplify the tasks associated with provisioning and maintaining a database. eG Enterprise offers to monitor the Microsoft SQL Database server hosted on AWS cloud using the Microsoft SQL on Cloud model (see Figure 1). To use this model, only a single eG remote agent is required; this agent sits on a remote host and collects the required metrics from the target database.

Figure 1 : Layer model of the Microsoft SQL on Cloud

The tests associated with each layer of this model has already been explained in the previous sections.