SQL Monitor is a web application that runs in your browser. It doesn't install anything on the servers you want to monitor. It comprises three components:
- The web server displays the SQL Monitor web interface.
- The base monitor is a Windows service that monitors your SQL Servers.
- The data repository is a SQL Server database that stores all the data collected by the base monitor.
Click in the installation wizard to read more about a SQL Monitor component or installation option.
For information about installing on an IIS server, see Using SQL Monitor with IIS.
If you want to access SQL Monitor through a firewall, see How do I access SQL Monitor through a firewall?
Where to install components
The web server and base monitor service can be installed on the same computer, or on different computers on your network.
The SQL Server database for the data repository can be hosted on any SQL Server instance, but the base monitor computer needs access to this database.
The base monitor service computer must be able to connect to:
- the SQL Servers you want to monitor, to collect data about their performance
- the data repository database, to store the collected data
The web server should be accessible by any PC or device on which you want to view the SQL Monitor client, and must be able to connect to the base monitor.
The data repository requires a SQL Server 2005, 2008 or 2012 database.
The base monitor and web server computers should always be switched on.
Account credentials required for installing
When you install and set up SQL Monitor, you need to provide credentials to connect:
- the base monitor service to the data repository (if you use a Windows account, this account will also run the base monitor service)
- to the machine (physical or virtual server) hosting the SQL Server you want to monitor
- to each SQL Server instance you want to monitor