﻿---
title: GCP Cloud SQL for SQL Server OpenTelemetry Assets
description: This package contains Kibana assets for monitoring Cloud SQL for SQL Server instances with Google Cloud Monitoring metrics collected by the OpenTelemetry...
url: https://docs-v3-preview.elastic.dev/elastic/integration-docs/tree/main/reference/gcp_cloudsql_sqlserver_otel
products:
  - Elastic integrations
applies_to:
  - Serverless Observability projects: Preview
  - Serverless Security projects: Preview
  - Elastic Stack: Planned
---

# GCP Cloud SQL for SQL Server OpenTelemetry Assets
|                                                                                                                               |                                                                   |
|-------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------|
| **Version**                                                                                                                   | 0.1.0 <applies-to>: Preview</applies-to> ([View all](#changelog)) |
| **Subscription level**[What's this?](https://www.elastic.co/subscriptions)                                                    | Basic                                                             |
| **Developed by**[What's this?](https://docs-v3-preview.elastic.dev/elastic/integration-docs/tree/main/reference/developed-by) | Elastic                                                           |
| **Minimum Kibana version(s)**                                                                                                 | 9.6.0                                                             |

<admonition title="The GCP Cloud SQL for SQL Server OpenTelemetry Assets integration v0.1.0 is in technical preview">
  To use pre-release integrations, go to the **Integrations** page in Kibana, scroll down, and toggle on the _Display beta integrations_ option.
</admonition>

This package contains Kibana assets for monitoring [Cloud SQL for SQL Server](https://cloud.google.com/sql/docs/sqlserver) instances with Google Cloud Monitoring metrics collected by the OpenTelemetry Collector.
The package is **content only**. It does not configure data collection. Use the **[Google Cloud Monitoring (OpenTelemetry)](https://www.elastic.co/docs/reference/integrations/googlecloudmonitor_input_otel)** input package (`googlecloudmonitor_input_otel`) to collect Cloud SQL for SQL Server metrics into Elasticsearch.

## Requirements

You need Elasticsearch for storing and searching your data and Kibana for visualizing and managing it.
You can use our hosted Elasticsearch Service on Elastic Cloud, which is recommended, or self-manage
the Elastic Stack on your own hardware.

## Setup

Install the **[Google Cloud Monitoring OpenTelemetry Input](https://www.elastic.co/docs/reference/integrations/googlecloudmonitor_input_otel)** package (`googlecloudmonitor_input_otel`) and configure it to collect Cloud SQL for SQL Server Cloud Monitoring metrics (for example, `cloudsql.googleapis.com/database/cpu/utilization`). This content package provides assets that visualize data collected by that input.
When configuring the input package, set the dataset name to `gcp.cloudsql_sqlserver.otel` so that data is written to the `metrics-gcp.cloudsql_sqlserver.otel-default` data stream, which these dashboards query.

## Dashboards


| Dashboard                                             | Description                                                                                                                                                                                             |
|-------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| **[GCP OTel] Cloud SQL - SQL Server Overview**        | Fleet overview of Cloud SQL for SQL Server instances. Covers availability, CPU, memory and disk saturation, batch throughput, and blocking.                                                             |
| **[GCP OTel] Cloud SQL - SQL Server Instance Detail** | Detail view of a single Cloud SQL for SQL Server instance. Covers availability, capacity, traffic and errors, connections, locking and blocking, memory and I/O, and high availability and replication. |


## Screenshots

This integration includes one or more Kibana dashboards that visualizes the data collected by the integration. The screenshots below illustrate how the ingested data is displayed.
<carousel>
  ![GCP Cloud SQL for SQL Server OTel Overview](https://epr.elastic.co/package/gcp_cloudsql_sqlserver_otel/0.1.0/img/gcp_cloudsql_sqlserver_otel-overview.png)

  ![GCP Cloud SQL for SQL Server OTel Details](https://epr.elastic.co/package/gcp_cloudsql_sqlserver_otel/0.1.0/img/gcp_cloudsql_sqlserver_otel-details.png)
</carousel>


## Changelog

<dropdown title="Changelog">
  | Version   | Details                                                                                                                                                                  | Minimum Kibana version |
  |-----------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------|
  | **0.1.0** | **Enhancement** ([View pull request](https://github.com/elastic/integrations/pull/21842))Initial draft of the GCP Cloud SQL for SQL Server OpenTelemetry Assets package. | 9.6.0                  |
</dropdown>