Add Azure SQL Server

This page refers to Azure SQL Database platform-as-a-service. If you wish to monitor an instance of SQL Server running on an Azure virtual machine (infrastructure-as-a-service), the virtual machine should be added to SQL Monitor in the usual way (seeAdding and managing monitored servers).

You can use SQL Monitor to monitor Azure SQL Databases and Azure Elastic Pools. Monitor adds all databases and elastic pools on any Azure SQL Server.  You can then exclude individual databases on the licensing page (see: Licensing).

You must have a server-level firewall rule that allows communication between the Base Monitor and the Azure SQL Server. This can be done through the Azure portal or PowerShell. If you have SSMS installed on the Base Monitor machine, attempting to connect through that will walk you through adding the required firewall rules.

  1. Go to the Configuration tab and under Monitoring, select Monitored servers.
  2. Click the Add Azure SQL Server button. The Add Azure SQL Server panel expands:

  3. In the Azure SQL Server field, enter the name of the Azure SQL Server you want to monitor. Note: you do not need to enter the .database.windows.net suffix, as it is added automatically.

  4. You will only need Azure SQL server credentials to connect.
  5. When you click Add, SQL Monitor attempts to add Azure SQL server and all the databases, Elastic Pools on that server:
Once added, server names can't be edited. If you typed the name incorrectly, the server will be added with a status of "Connection failed (Unreachable)". To fix this, remove the server and add it again.

Once a connection is established and a data collection event succeeded, the status is displayed as Monitoring (Connected). If SQL Monitor encounters a problem and displays a different status, see Monitoring status explained.




Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?