• /
  • ログイン
  • 無料アカウント

Azure Database for PostgreSQL monitoring integration

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

Features

New Relic gathers database data from the Azure Database for PostgreSQL service, which provides fully managed, enterprise-ready PostgreSQL Community database as a service. The service provides high availability, elastic scaling, automatic backups, and data protection at-rest and in-motion.

Using New Relic, you can:

Activate integration

Follow standard procedures to activate your Azure service in New Relic.

Configuration and polling

New Relic queries your Azure Database services according to a default polling interval, which varies depending on the integration. For Azure Database for PostgreSQL integrations:

  • Polling interval: 5 minutes (maximum recommended polling frequency: 1 hour)
  • Resolution: 1 data point per minute

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

View and use data

To explore your integration data: Go to one.newrelic.com > Infrastructure > Azure > (select an integration).

You can query and explore your data using the AzurePostgreSqlServerSample event type, with a provider value of AzurePostgreSqlServer.

Metric data

This integration collects the following metric data.

Database sample metrics

Metric

Description

activeConnections

Count of active connections.

backupStorageUsedBytes

Backup storage used, in bytes.

connectionsFailed

Count of failed connections.

cpuPercent

Percentage of CPU used.

ioConsumptionPercent

Percentage of I/O consumption used.

memoryPercent

Percentage of memory used.

networkEgressBytes

Network Out across active connections, in bytes.

networkIngressBytes

Network In across active connections, in bytes.

pgReplicaLogDelayBytes

Replication lag, in bytes.

pgReplicaLogDelaySeconds

Replication lag, in seconds.

serverlogStorageLimitBytes

Server log storage limit, in bytes.

serverlogStoragePercent

Percentage of server log storage used.

serverlogStorageUsageBytes

Server log storage used, in bytes.

storageLimitBytes

Amount of storage available, in bytes.

storagePercent

Percentage of available storage used.

storageUsedBytes

Amount of storage used, in bytes.

Inventory data

This integration collects the following inventory data about your system's state and configuration. For more information, see the Microsoft Azure PostgreSQL documentation.

azure/postgresql/server

  • administratorLogin
  • configuration
  • databaseNames
  • databases, including id, name, type, charset, and collation
  • domainName
  • earliestRestoreDate
  • firewalls, including id, name, type, startIpAddress, and endIpAddress
  • geoRedundantBackup
  • isReplica
  • MasterServerid (only for a replica server)
  • maxConnections
  • name
  • regionName
  • replicaCapacity (only for a replica server)
  • replicationRole (only for a replica server)
  • resourceGroupName
  • skuCapacity
  • skuFamily
  • skuName
  • skuTier
  • sslEnforcement
  • storageAutoGrow
  • tags
  • type
  • userVisibleState
  • version

その他のヘルプ

さらに支援が必要な場合は、これらのサポートと学習リソースを確認してください:

問題を作成するこのページを編集する
Copyright © 2020 New Relic Inc.