Google Cloud Spanner monitoring integration

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

New Relic Infrastructure's integrations with the Google Cloud Platform (GCP) include an integration to report Google Cloud Spanner data to New Relic products. This document explains how to activate the GCP Cloud Spanner integration and describes the data that can be reported.

Features

Google Cloud Spanner service is a globally-distributed relational database service built for the cloud. Using the Google Spanner Console, developers can create a Cloud Spanner instance, add schemas, write and modify data, and run queries.

Activate integration

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

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

To enable the integration:

Make sure you have installed the Infrastructure agent before you activate GCP integrations from your Infrastructure account.
Follow standard procedures to connect your GCP service to New Relic Infrastructure.

Polling frequency

New Relic Infrastructure integrations query your GCP services according to a polling interval, which varies depending on the integration. The polling frequency for Google Cloud Spanner is five minutes. The resolution is 1 data point every minute.

Find and use data

After activating the integration and waiting a few minutes (based on the polling frequency), data will appear in the New Relic UI. To find and use your data, including links to your dashboards and alert settings, go to infrastructure.newrelic.com > Integrations > Google Cloud Platform > (select an integration).

Metric data

To view metric data for your GCP Spanner integration in Insights, create NRQL queries for GcpSpannerInstanceSample and GcpSpannerDatabaseSample events and their related attributes.

GcpSpannerInstanceSample

Query GcpSpannerInstanceSample events in Insights to view data for the following attributes:

Attribute	Description
`instance.cpu.Utilization`	Utilization of the provisioned CPU, between 0 and 1.
`instance.nodes`	Total number of nodes.
`instance.sessions`	Number of sessions in use.
`instance.storage.UsedBytes`	Storage used in bytes.

GcpSpannerDatabaseSample

Query GcpSpannerDatabaseSample events in Insights to view data for the following attributes:

Attribute	Description
`api.ReceivedBytes`	Uncompressed request bytes received by Cloud Spanner.
`api.Requests`	Rate of Cloud Spanner API requests.
`api.RequestLatencies`	Distribution of server request latencies for a database. This includes latency of request processing in Cloud Spanner backends and API layer. It does not include network or reverse-proxy overhead between clients and servers.
`api.SentBytes`	Uncompressed response bytes sent by Cloud Spanner.

Inventory data

To view inventory data for GCP Spanner services, go to infrastructure.newrelic.com > Integrations > Inventory and search for or select the following:

gcp/spanner/instance

Name	Description
`projectId`	The project where the instance is.
`zone`	The region where the instance is.
`name`	The Id of the instance (not the name).
`state*`	The state of the instance.
`nodeCount*`	The number of nodes the instance has.
`instanceName*`	The name of the instance.
`labels*`	The labels set for the instance.

* Only available if the GCP project is linked to New Relic through a service account.

gcp/spanner/database

Name	Description
`projectId`	The project where the database is.
`zone`	The region where the database is.
`name`	The Id of the database (not the name).
`instanceId`	The Id of the instance where the database is.
`dl*`	The SQL definition of the instance.
`state*`	The state of the database.