When you install SQL Monitor, you configure three components:
- the web server, which hosts the SQL Monitor web interface
- the monitoring service (also called the base monitor), a Windows service that collects data about your SQL Servers
- the SQL Monitor database (also called the data repository), a SQL Server database that stores data about your SQL Servers
SQL Monitor doesn't install anything on the instances you monitor.
You should install the SQL Monitor components on a different machine from the one that hosts the SQL Servers you want to monitor. Otherwise, if the SQL Server fails, you won't be able to access SQL Monitor.
When you install and set up SQL Monitor, you need to provide credentials to connect:
- the monitoring service to the SQL Monitor database (if you use a Windows account, this account will also run the monitoring service)
- to the machine that hosts the SQL Server you want to monitor
- to every instance you want to monitor
After you install
To start using SQL Monitor, you need to create the Administrator role in the SQL Monitor UI.
To open SQL Monitor:
- If you installed the SQL Monitor web server, in the Start menu, select Red Gate > SQL Monitor.
- If you configured your own web server using IIS, open the SQL Monitor website you configured.