--- 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. |