• EnglishEspañol日本語한국어Português
  • Log inStart now

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:

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 AzureSqlElasticPoolSampleevent 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.

Copyright © 2024 New Relic Inc.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.