SQL Monitor 10

Having multiple components which span different technologies, there are several options when implementing SQL Monitor as a High Availability solution.

This page describes:

SQL Monitor components and popular High Availability options.
How to install SQL Monitor with High Availability.
Upgrading a SQL Monitor High Availability installation.

SQL Monitor components and popular High Availability options

Data repository

Making a SQL Server database highly available is common and the same techniques can be used for the SQL Monitor database, the most popular being:

Availability Group.
SQL Server Failover Cluster instance.

Web Server

When choosing a Web Server to use with SQL Monitor, there are two installation options: default SQL Monitor Web Server (IIS Express) and your own IIS Server.

Users choosing their own IIS Server can use existing techniques to make that IIS Server highly available.

If using the default SQL Monitor Web Server, this can be configured as a Windows Failover Cluster Resource (see below).

Monitoring service

This can be configured as a Windows Failover Cluster Resource (see below).

Installation guide

The steps required to configure SQL Monitor as a High Availability solution.
This example uses the following methods:

Data repository – Availability Group database.
Web server – Windows Failover Cluster resource.
Monitoring service – Windows Failover Cluster resource.

This guide requires a Windows Failover Cluster to have been pre-configured and SQL Server instances available to be part of an Availability Group, as well as prior knowledge of configuring Availability Groups.

Installation steps

To use an Availability Group database as part of the solution, create an empty database, Availability Group and Availability Group listener using your preferred method.
Copy the SQL Monitor installer to all nodes on your Windows Failover Cluster.

Run the SQL Monitor installer, selecting the default options of installing both the default Web interface and monitoring service and choose a port that the web interface will be accessible over.
When asked to specify a database for the repository, choose Select database and Use an existing database. Specify the Availability Group listener and database previously created.
Complete the remainder of the installation wizard and install.
When the installation has completed, load the web interface and specify an Administrator password.
Close the web interface.
Open Services.msc.
Locate the SQL Monitor Base Monitor and SQL Monitor Web Server services.
For each service, open Properties and set the Start type to Manual.
Stop both the SQL Monitor Base Monitor and SQL Monitor Web Server services.

Run the SQL Monitor installer, configuring the same options as when installing onto the passive node.
When the installation has completed, load the web interface and enter the Administrator password.
Close the web interface.
Open Services.msc.
Locate the SQL Monitor Base Monitor and SQL Monitor Web Server services.
For each service, open Properties and set the Start type to Manual.

Run the Failover Cluster Manager and connect to the Windows Failover Cluster.
Click Roles and select an existing role, or create a new empty role.
With the role selected, choose Add Resource > Generic Service from the Actions section on the right-hand side.
Select the SQL Monitor Base Monitor service from the services list.
Complete the wizard.
Repeat the above for the SQL Monitor Web Server service.
With the role selected, open the Resources tab from the bottom pane.
For each SQL Monitor resource, right-click and choose Bring online.
Attempt to connect to the SQL Monitor web interface using a browser and the Windows Cluster name (or Availability Group listener name if you selected an existing Availability Group role) and verify it is working.

Upgrade guide

When configuring SQL Monitor in this way, extra steps are needed to successfully upgrade the Web Server and Monitoring service.

Upgrade steps

Open Failover Cluster Manager and connect to the Windows Failover Cluster.
Locate the SQL Monitor Base Monitor and Web Server resources in your role.
Right-click each resource and Take offline.

Run the SQL Monitor installer and complete the installation.
Open Services.msc.
Locate the SQL Monitor Base Monitor and SQL Monitor Web Server services.
For each service, open Properties and set the Start type to Manual.
Stop both the SQL Monitor Base Monitor and SQL Monitor Web Server services.

Run the SQL Monitor installer and complete the installation.
Open Services.msc.
Locate the SQL Monitor Base Monitor and SQL Monitor Web Server services.
For each service, open Properties and set the Start type to Manual.
Stop both the SQL Monitor Base Monitor and SQL Monitor Web Server services.
Open Failover Cluster Manager and connect to the Windows Failover Cluster.
Locate the SQL Monitor Base Monitor and Web Server resources in your role.
Right-click each resource and Bring online.