---
title: Arc Data Sql Server Instance
description: Datadog, the leading service for cloud-scale monitoring.
breadcrumbs: Docs > DDSQL Reference > Data Directory > Arc Data Sql Server Instance
---

# Arc Data Sql Server Instance

This table represents the arc_data_sql_server_instance resource from Microsoft Azure.

```
azure.arc_data_sql_server_instance
```

## Fields

| Title                              | ID   | Type       | Data Type                                                                                                                                                                                 | Description |
| ---------------------------------- | ---- | ---------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------- |
| _key                               | core | string     |
| azure_defender_status              | core | string     | Status of Azure Defender.                                                                                                                                                                 |
| azure_defender_status_last_updated | core | string     | Timestamp of last Azure Defender status update.                                                                                                                                           |
| collation                          | core | string     | SQL Server collation.                                                                                                                                                                     |
| container_resource_id              | core | string     | ARM Resource id of the container resource (Azure Arc for Servers).                                                                                                                        |
| create_time                        | core | string     | The time when the resource was created.                                                                                                                                                   |
| current_version                    | core | string     | SQL Server current version.                                                                                                                                                               |
| edition                            | core | string     | SQL Server edition.                                                                                                                                                                       |
| host_type                          | core | string     | Type of host for Azure Arc SQL Server                                                                                                                                                     |
| id                                 | core | string     | Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName} |
| instance_name                      | core | string     | SQL Server instance name.                                                                                                                                                                 |
| license_type                       | core | string     | SQL Server license type.                                                                                                                                                                  |
| location                           | core | string     | The geo-location where the resource lives                                                                                                                                                 |
| name                               | core | string     | The name of the resource                                                                                                                                                                  |
| patch_level                        | core | string     | SQL Server update level.                                                                                                                                                                  |
| product_id                         | core | string     | SQL Server product ID.                                                                                                                                                                    |
| provisioning_state                 | core | string     | The provisioning state of the Arc-enabled SQL Server resource.                                                                                                                            |
| resource_group                     | core | string     |
| status                             | core | string     | The cloud connectivity status.                                                                                                                                                            |
| subscription_id                    | core | string     |
| subscription_name                  | core | string     |
| system_data                        | core | json       | Azure Resource Manager metadata containing createdBy and modifiedBy information.                                                                                                          |
| tags                               | core | hstore_csv |
| tcp_dynamic_ports                  | core | string     | Dynamic TCP ports used by SQL Server.                                                                                                                                                     |
| tcp_static_ports                   | core | string     | Static TCP ports used by SQL Server.                                                                                                                                                      |
| type                               | core | string     | The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"                                                                                 |
| v_core                             | core | string     | The number of logical processors used by the SQL Server instance.                                                                                                                         |
| version                            | core | string     | SQL Server version.                                                                                                                                                                       |