# Source: https://docs.datadoghq.com/ddsql_reference/data_directory/azure/azure.sql_server_managed_instance.dataset.md

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

# SQL Server Managed Instance

This table represents the SQL Server Managed Instance resource from Microsoft Azure.

```
azure.sql_server_managed_instance
```

## Fields

| Title                               | ID   | Type       | Data Type                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | Description |
| ----------------------------------- | ---- | ---------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------- |
| _key                                | core | string     |
| administrator_login                 | core | string     | Administrator username for the managed instance. Can only be specified when the managed instance is being created (and is required for creation).                                                                                                                                                                                                                                                                                                                                                                                                 |
| administrators                      | core | json       | The Azure Active Directory administrator of the server.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| collation                           | core | string     | Collation of the managed instance.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| current_backup_storage_redundancy   | core | string     | The storage account type used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)                                                                                                                                                                                                                                                                                                                                    |
| dns_zone                            | core | string     | The Dns Zone that the managed instance is in.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| dns_zone_partner                    | core | string     | The resource id of another managed instance whose DNS zone this managed instance will share after creation.                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| fully_qualified_domain_name         | core | string     | The fully qualified domain name of the managed instance.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| id                                  | core | string     | Resource ID.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| identity                            | core | json       | The Azure Active Directory identity of the managed instance.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| instance_pool_id                    | core | string     | The Id of the instance pool this managed server belongs to.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| key_id                              | core | string     | A CMK URI of the key to use for encryption.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| license_type                        | core | string     | The license type. Possible values are 'LicenseIncluded' (regular price inclusive of a new SQL license) and 'BasePrice' (discounted AHB price for bringing your own SQL licenses).                                                                                                                                                                                                                                                                                                                                                                 |
| location                            | core | string     | Resource location.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| maintenance_configuration_id        | core | string     | Specifies maintenance configuration id to apply to this managed instance.                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| managed_instance_create_mode        | core | string     | Specifies the mode of database creation.Default: Regular instance creation.Restore: Creates an instance by restoring a set of backups to specific point in time. RestorePointInTime and SourceManagedInstanceId must be specified.                                                                                                                                                                                                                                                                                                                |
| minimal_tls_version                 | core | string     | Minimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| name                                | core | string     | Resource name.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| primary_user_assigned_identity_id   | core | string     | The resource id of a user assigned identity to be used by default.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| private_endpoint_connections        | core | json       | List of private endpoint connections on a managed instance.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| provisioning_state                  | core | string     |
| proxy_override                      | core | string     | Connection type used for connecting to the instance.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| public_data_endpoint_enabled        | core | bool       | Whether or not the public data endpoint is enabled.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| requested_backup_storage_redundancy | core | string     | The storage account type to be used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)                                                                                                                                                                                                                                                                                                                              |
| resource_group                      | core | string     |
| restore_point_in_time               | core | string     | Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.                                                                                                                                                                                                                                                                                                                                                                                                                             |
| service_principal                   | core | json       | The managed instance's service principal.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| sku                                 | core | json       | Managed instance SKU. Allowed values for sku.name: GP_Gen4, GP_Gen5, BC_Gen4, BC_Gen5                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| source_managed_instance_id          | core | string     | The resource identifier of the source managed instance associated with create operation of this instance.                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| state                               | core | string     | The state of the managed instance.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| storage_size_in_gb                  | core | int64      | Storage size in GB. Minimum value: 32. Maximum value: 8192. Increments of 32 GB allowed only.                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| subnet_id                           | core | string     | Subnet resource ID for the managed instance.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| subscription_id                     | core | string     |
| subscription_name                   | core | string     |
| tags                                | core | hstore_csv |
| timezone_id                         | core | string     | Id of the timezone. Allowed values are timezones supported by Windows.Windows keeps details on supported timezones, including the id, in registry underKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones.You can get those registry values via SQL Server by querying SELECT name AS timezone_id FROM sys.time_zone_info.List of Ids can also be obtained by executing [System.TimeZoneInfo]::GetSystemTimeZones() in PowerShell.An example of valid timezone id is "Pacific Standard Time" or "W. Europe Standard Time". |
| type                                | core | string     | Resource type.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| v_cores                             | core | int64      | The number of vCores. Allowed values: 8, 16, 24, 32, 40, 64, 80.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| zone_redundant                      | core | bool       | Whether or not the multi-az is enabled.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |