How to add servers to ApexSQL Monitor

ApexSQL Monitor doesn’t automatically monitor any SQL Server instances. To monitor an SQL Server instance, it has to be added manually.

  • Q: How are SQL Server instances added in ApexSQL Monitor?

    1. Click Add server on the Home tab in the ApexSQL Monitor menu

    2. Select a local SQL Server instance from the Server drop-down list, authentication type, and enter the credentials if you selected the SQL Server authentication.

      To add a remote SQL Server instance to ApexSQL Monitor, or a local one that’s not shown in the drop-down list, type the remote SQL Server instance name as <Machine_Name>\<SQL_Instance_Name>, or <Machine_IP_Address>\<SQL_Instance_Name>.

  • Q: Are there any permissions required to add a local SQL Server instance?

    A: To be able to add a local SQL Server instance to ApexSQL Monitor, the specified login must be a member of the Windows administrator group and have the sysadmin role on the SQL Server instance. Once the SQL Server instance is added to monitoring, the sysadmin role is not required anymore, GRANT VIEW ANY DATABASE, GRANT VIEW SERVER STATE and GRANT VIEW ANY DEFINITION permissions are sufficient.

  • Q: Are there any permissions required to add a remote SQL Server instance?

    A: Permissions required to add a remote SQL Server instance are: a Windows user member of Performance Log Users, Performance Monitor Users groups and the Event Log Readers groups and public role on the remote SQL Server instance and the following permissions: CONNECT SQL, VIEW ANY DATABASE, VIEW ANY DEFINITION and VIEW SERVER STATE.

  • Q: How can SQL Server instances be removed?

    A: To remove an SQL Server instance, select it in the SQL Server instances pane and click Remove server on the Home tab in the ApexSQL Monitor menu.

Note that the Schedule all available measurements option is selected by default. That means that all metrics available for monitoring will be monitored and alerts will be triggered for their default threshold values. It’s recommended that custom values for low, medium, and high thresholds be set, according to a user’s specific monitoring goals, environment, and company policy. A distinct set of metrics and values can be configured for each monitored SQL Server instance in ApexSQL Monitor.

Monitored SQL Server instances are shown in the SQL Server instances pane on the left.