Azure SQL Database - FAQ

Azure SQL Database - FAQ

1. Why have we removed the Diagnostic Settings dependency in Azure SQL Database monitor?
  1. Till APM v15240:
    1. Azure SQL Database was using Diagnostic Settings to perform data collection.
    2. Prerequisites had to be fulfilled to turn on Diagnostic Settings for data collection.
    3. A Diagnostic Storage Account to be provided in edit monitor page to facilitate data collection.
  2. From APM v15240:
    1. Azure SQL Database monitor has been enhanced to use Azure APIs and the Diagnostic Settings dependency has been removed.
    2. There are no perquisites for data collection.
    3. Diagnostic Storage Account details in the edit monitor page need not be given to facilitate data collection.
2. What happens in Applications Manager when you delete Azure SQL Database in  the Azure portal?
  1. When an Azure SQL Database is deleted in Azure portal, the monitor status depends on the 'Action on Deleted Resources' option.
    1. Continue Alerting: The monitor will continue generating alerts indicating that the Azure SQL Database has been deleted.
    2. Stop Alerting: The monitor will stop generating alerts about the deleted Azure SQL Database.
    3. Unmanage Resource:  The monitor will transition to an unmanaged state.
    4. Delete ResourceThe monitor will be removed entirely from Applications Manager.
  2. Furthermore, an entry will be added in Audit logs upon deletion of Azure monitors in Applications Manager. You can check this under Settings → Tools → Audit logs  choose Actions as 'Azure Monitors Deletion'.


3. DTU (Database Transaction Unit) based metrics are specific for DTU-based SQL Databases:
  1. DTU based metrics (DTU Limit, DTU Used, DTU Utilization) are supported only for Basic, Standard, Premium tiers and is not supported for other types like vCore-based SQL Databases.
  2. This is because other SQL database types do not have DTU based metrics.
4. API used for data collection:
  1. Configuration metrics are collected using Azure SQL Database API.
  2. Performance data is collected using Azure Monitor API.
  3. These are the supported Azure Monitor metrics for SQL Database.
5. Troubleshooting:
  1. Adding Client IP to Azure firewall.
  2. TCP/IP connection to the host <Azure SQL server> on port 1433 has failed.

                  New to ADSelfService Plus?

                    • Related Articles

                    • Azure SQL Database - Troubleshooting - Add client IP to Azure firewall

                      "Connection to the database failed with error : Cannot open server <ServerName> requested by the login. Client with IP address <SomeIP> is not allowed to access the server.  To enable access, use the Windows Azure Management Portal or run ...
                    • Microsoft Azure - FAQ

                      1. What happens to the Azure monitor in Applications Manager when you delete any of the supported services from the Azure portal? When a resource is deleted in Azure portal, the monitor status depends on the 'Action on Deleted Resources' option. ...
                    • Azure SQL Database - TCP/IP connection to the host <Azure SQL server> on port 1433 has failed

                      "Connection to the database failed with error : The TCP/IP connection to the host <Azure SQL server>, port 1433 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL ...
                    • Azure Storage Account - FAQ

                      1. Why have we removed the Diagnostic Settings dependency in Azure Storage Account monitor? Till APM v15300: Azure Storage Account monitor was using Diagnostic Settings to perform data collection. Azure Storage Account monitor was dependent on ...
                    • Azure Virtual Machine - FAQ

                      1. How is data collection happening for Azure Virtual Machine monitors? Microsoft Azure monitor discovery modes in AppManager: AD Application mode Organizational Account mode OAuth mode Azure VM monitor - Data collection methods: Azure Monitor Azure ...