Azure SQL Database monitoring integration

Access to this feature depends on your subscription level. Requires Infrastructure Pro.

New Relic Infrastructure's integrations include an integration for reporting your Microsoft Azure SQL Database metrics and inventory data to New Relic products. This document explains how to activate the integration and describes the data reported.

Features

New Relic Infrastructure 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 Infrastructure dashboards.
  • Run custom queries and visualize the data in New Relic Insights.
  • Create alert conditions to notify you of changes in data.

Activate integration

Anyone can view and explore the Azure data reporting to your New Relic Infrastructure account.

Only Owner, Admins, or Infrastructure add-on managers can manage the Azure integrations.

To enable the integration:

  1. Make sure you have installed the Infrastructure agent before you activate Azure integrations from your Infrastructure account.
  2. Follow standard procedures to activate your Azure service in New Relic Infrastructure.

Configuration and polling

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

New Relic Infrastructure integrations query 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 in Infrastructure, go to infrastructure.newrelic.com > Integrations > (select an integration).

In New Relic Insights, data is organized like this:

Azure SQL Database data Organized in New Relic Insights
Single database
  • Data about a single database is attached to AzureSqlDatabaseSample event type.
  • Inventory data has a provider value of AzureSqlDatabase.
Elastic pool
  • Data about an elastic pool is attached to AzureSqlElasticPoolSampleevent type.
  • Inventory data has a provider value of AzureSqlElasticPool.
Firewall
  • Data about a firewall is attached to AzureSqlFirewallSample event type.
  • Inventory data has a provider value of AzureSqlFirewall.
Database replication link
  • Data about a database replication link is attached to AzureSqlReplicationLinkSample event type.
  • Inventory data has a provider value of AzureSqlReplicationLink.
Database restore point
  • Data about a database restore point is attached to AzureSqlRestorePointSample event type.
  • Inventory data has a provider value of AzureSqlRestorePoint.
Logical server
  • Data about a logical server is attached to AzureSqlServerSample event type.
  • Inventory data has a provider value of AzureSqlServer.

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.

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.

Inventory data

This integration collects the following inventory data about your system's state and configuration.

azure/sql/database/

  • collation
  • creationDate
  • defaultSecondaryLocation
  • earliestRestoreDate
  • edition
  • elasticPoolName
  • isDataWarehouse
  • maxSizeBytes
  • name
  • regionName
  • resourceGroupName
  • sqlServerName
  • status
  • transparentDataEncryptionStatus
  • type

azure/sql/elasticpool/

  • creationDate
  • databaseDtuMax
  • databaseDtuMin
  • dtu
  • edition
  • name
  • regionName
  • resourceGroupName
  • sqlServerName
  • state
  • storageMb
  • type

azure/sql/firewall

  • endIpAddress
  • name
  • regionName
  • resourceGroupName
  • sqlServerName
  • startIpAddress
  • databaseName
  • name
  • partnerDatabase
  • partnerLocation
  • regionName
  • replicationState
  • resourceGroupName
  • role
  • sqlServerName
  • startTime

azure/sql/restore-point/

  • databaseName
  • earliestRestoreDate
  • name
  • regionName
  • resourceGroupName
  • restorePointType
  • sqlServerName

For more help

Recommendations for learning more: