---
title: Azure SQL Database monitoring integration
source: https://docs.newrelic.com/docs/infrastructure/microsoft-azure-integrations/azure-integrations-list/azure-sql-database-monitoring-integration
---

[New Relic's integrations](https://docs.newrelic.com/docs/infrastructure/introduction-infra-monitoring) include an integration for reporting your [Microsoft Azure SQL Database](https://azure.microsoft.com/en-us/services/sql-database/) metrics and other data to New Relic. This document explains how to activate the integration and describes the data reported.

## Features

New Relic gathers database data from Azure's fully-managed relational cloud database service. Azure SQL provides single databases with their own set of resources, and elastic pools that share a set of resources. Both are associated with an Azure SQL Database logical server. If databases are protected by a firewall, they can be replicated and restored to a previous point in time.

Using New Relic, you can:

-   View Azure SQL Database data in pre-built dashboards.
-   [Run custom queries and visualize the data](https://docs.newrelic.com/docs/using-new-relic/data/understand-data/query-new-relic-data).
-   Create alert conditions to notify you of changes in data.

## Activate integration [#activate]

To enable the integration follow standard procedures to [activate your Azure service in New Relic](https://docs.newrelic.com/docs/infrastructure/microsoft-azure-integrations/getting-started/activate-azure-integrations).

## Configuration and polling [#polling]

You can change the polling frequency and filter data using [configuration options](https://docs.newrelic.com/docs/integrations/new-relic-integrations/getting-started/configure-polling-frequency-data-collection-cloud-integrations).

New Relic queries your Azure Database services according to a default [polling](https://docs.newrelic.com/docs/integrations/microsoft-azure-integrations/getting-started/azure-integration-polling) interval, which varies depending on the integration. Polling frequency for the Azure SQL Database integration:

-   Polling interval: 5 minutes
-   Resolution: 1 data point per minute

## Find and use data [#find-and-use]

To [explore your integration data](https://docs.newrelic.com/docs/infrastructure/integrations/find-use-infrastructure-integration-data), go to **[one.newrelic.com > All capabilities](https://one.newrelic.com/all-capabilities) > Infrastructure > Azure > (select an integration)**.

Data is organized like this:

| **Azure SQL Database data** | **Organized in New Relic**                                                                          |
| --------------------------- | --------------------------------------------------------------------------------------------------- |
| Single database             | - Data about a single database is attached to `AzureSqlDatabaseSample` event type.                  |
| Elastic pool                | - Data about an elastic pool is attached to `AzureSqlElasticPoolSample`event type.                  |
| Firewall                    | - Data about a firewall is attached to `AzureSqlFirewallSample` event type.                         |
| Database replication link   | - Data about a database replication link is attached to `AzureSqlReplicationLinkSample` event type. |
| Database restore point      | - Data about a database restore point is attached to `AzureSqlRestorePointSample` event type.       |
| Logical server              | - Data about a logical server is attached to `AzureSqlServerSample` event type.                     |

## Metric data [#metrics]

This integration collects the following [metric data](https://docs.newrelic.com/docs/infrastructure/integrations-getting-started/getting-started/understand-integration-data-data-types#metric):

### Database sample metrics [#database-sample]

| Metric                      | Description                                              |
| --------------------------- | -------------------------------------------------------- |
| `cpuPercent`                | Average CPU percentage.                                  |
| `physicalDataReadPercent`   | Average data IO percentage.                              |
| `logWritePercent`           | Average log IO percentage.                               |
| `dtuConsumptionPercent`     | Average DTU percentage.                                  |
| `storage`                   | Total database size, in bytes.                           |
| `connectionSuccessful`      | Total number of successful connections.                  |
| `connectionFailed`          | Total number of failed connections.                      |
| `blockedByFirewall`         | Total number of requests blocked by firewall.            |
| `deadlock`                  | Total number of deadlocks.                               |
| `storagePercent`            | Database size percentage.                                |
| `xtpStoragePercent`         | Average in-memory OLTP storage percent.                  |
| `workersPercent`            | Average workers percentage.                              |
| `sessionsPercent`           | Average sessions percentage.                             |
| `dtuLimit`                  | Average number of DTU limit.                             |
| `dtuUsed`                   | Average number of used DTU.                              |
| `dwuLimit`                  | DWU limit.                                               |
| `dwuConsumptionPercent`     | Percentage of DWU.                                       |
| `dwuUsed`                   | Number of used DWU.                                      |
| `dwCpuPercent`              | Average DW node level CPU percentage.                    |
| `dwPhysicalDataReadPercent` | Average DW node level data IO percentage.                |
| `databaseSizeCurrentBytes`  | Total current database size in bytes.                    |
| `databaseSizeLimitBytes`    | Database limit in bytes.                                 |
| `cpuLimit`                  | Average limit of CPUs. Applies to vCore-based databases. |

### Elastic pool sample metrics [#elastic-pool]

| Metric                            | Description                                  |
| --------------------------------- | -------------------------------------------- |
| `cpuPercent`                      | Average CPU percentage.                      |
| `databaseCpuPercent`              | Average CPU percentage, per database.        |
| `physicalDataReadPercent`         | Average data IO percentage.                  |
| `databasePhysicalDataReadPercent` | Average data IO percentage, per database.    |
| `logWritePercent`                 | Average log IO percentage.                   |
| `databaseLogWritePercent`         | Average log IO percentage, per database.     |
| `dtuConsumptionPercent`           | Average DTU percentage.                      |
| `databaseDtuConsumptionPercent`   | Average DTU percentage, per database.        |
| `storagePercent`                  | Average storage percentage.                  |
| `workersPercent`                  | Average workers percentage.                  |
| `databaseWorkersPercent`          | Average workers percentage, per database.    |
| `sessionsPercent`                 | Average sessions percentage.                 |
| `databaseSessionsPercent`         | Average sessions percentage, per database.   |
| `eDTULimit`                       | Average DTU limit.                           |
| `storageLimitBytes`               | Average storage limit, in bytes.             |
| `eDTUUsed`                        | Average used eDTU.                           |
| `storageUsedBytes`                | Average used storage, in bytes.              |
| `databaseStorageUsedBytes`        | Average used storage per database, in bytes. |
| `xtpStoragePercent`               | Average in-memory OLTP storage percent.      |

### Server sample metrics [#server-sample]

| Metric       | Description                                                         |
| ------------ | ------------------------------------------------------------------- |
| `dtuCurrent` | Average utilization percentage relative to the DTU of the database. |
| `dtuLimit`   | Database DTU limit.                                                 |