These pages cover SQL Monitor 7, which is not the latest version. Help for other versions is also available.
Installing SQL Monitor with High Availability
Published 19 February 2018
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 HA options
- How to install SQL Monitor with High Availability
- Upgrading a SQL Monitor HA installation
SQL Monitor components and popular HA 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 (instructions below)
Monitoring service
This can be configured as a Windows Failover Cluster Resource (instructions 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
Upgrade guide
When configuring SQL Monitor in this way, extra steps are needed to successfully upgrade the Web server and Monitoring service.