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 you delete Azure SQL Database in Azure portal, The Azure SQL Database (child monitor) in Applications Manager will be deleted in Azure parent monitor's next poll and the following message will be displayed in the child monitor.

  1. In Azure Parent Monitor, the child monitor will be removed in the next poll. Until then, the status of the Azure SQL Database will be shown as 'Deleted'.


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.

          • 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 Azure monitor in Applications Manager when you delete any of the supported services from the Azure portal? When you perform a delete operation on any of the supported Azure resources in the Azure portal, the respective monitor will ...
          • 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 ...
          • Error message while performing database backup of Applications Manager

            While performing a database backup operation of Applications Manager build with Pgsql backend, you may encounter the following error, especially when your database size has grown bigger with a large number of tables.   pg_dump: WARNING: out of shared ...