You can use Redgate 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). 

1. Go to the Configuration page and under Estate, select Monitored servers.
2. Click Add > Azure SQL Database. The Add Azure SQL Database panel expands:

   

3. In the Azure SQL Server field, enter the name of the Azure SQL Server you want to monitor ensuring you enter the .database.windows.net suffix (unless using an alternative host name).
   

4. You will need to select your preferred Authentication Method and enter the corresponding credentials to connect.

   New name for Azure AD

   Azure Active Directory (Azure AD) has been renamed to Microsoft Entra ID.

   As we transition to the new name, you may notice either name used in Redgate Monitor.

   
   

   1. We support the following authentication methods for Redgate Monitor to gain access to the Azure SQL Database:
      1. SQL Server Authentication
         • This method uses logins created in SQL Server. You must supply a username and password so that Redgate Monitor can connect to the instance for monitoring.
         • All credentials are stored securely in the base monitor database.
         • For more information see here
      2. Microsoft Entra – Password
         • This method requires a Microsoft Entra ID to be associated with the Azure SQL Database. You must supply a username and password for an account provisioned on the Microsoft Entra ID that has sufficient access to the Azure SQL Database.
         • All credentials are stored securely in the base monitor database.
      3. Microsoft Entra – Integrated
         • This method requires a Microsoft Entra ID to be associated with the Azure SQL Database and should be setup for Integrated access.
      4. Microsoft Entra - Managed Identity
         • This method requires a system-assigned or user-assigned managed identity to be associated with the Azure SQL Database.
         • For user-assigned managed identities, the Client/App ID will need to be specified.
         • For more information see here.
         • The Client/App ID is stored securely in the base monitor database. 

1. When you click Next , Redgate Monitor will navigate to the Select databases page which allows you to select the databases that need to be monitored.
   1. You are given two options for monitoring databases.
      1. Automatically detect and monitor new databases:  This option requires no further actions and Redgate Monitor will automatically detect and add all the databases currently available and continue to add databases created in the future.
      2. Manually select databases to monitor:  This option requires you to select the databases that need to be added to Redgate Monitor, you are required to select at least one database to proceed with this option.
2. When you click Add , Redgate Monitor attempts to add the Azure SQL server, Elastic Pools and the databases based on your selection on that server:

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