Azure SQL Database monitoring integration

New Relic's integrations include an integration for reporting your Microsoft Azure 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.
Create alert conditions to notify you of changes in data.

Activate integration

To enable the integration follow standard procedures to activate your Azure service in New Relic.

Configuration and polling

You can change the polling frequency and filter data using configuration options.

New Relic queries your Azure Database services according to a default 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

To explore your integration data, go to 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

This integration collects the following metric data:

Database sample metrics

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

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

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