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

# Sql Virtual Machine Sql Virtual Machine

This table represents the sql_virtual_machine_sql_virtual_machine resource from Microsoft Azure.

```
azure.sql_virtual_machine_sql_virtual_machine
```

## Fields

| Title                                     | ID   | Type       | Data Type                                                                                        | Description |
| ----------------------------------------- | ---- | ---------- | ------------------------------------------------------------------------------------------------ | ----------- |
| _key                                      | core | string     |
| assessment_settings                       | core | json       | SQL best practices Assessment Settings.                                                          |
| auto_backup_settings                      | core | json       | Auto backup settings for SQL Server.                                                             |
| auto_patching_settings                    | core | json       | Auto patching settings for applying critical security updates to SQL virtual machine.            |
| enable_automatic_upgrade                  | core | bool       | Enable automatic upgrade of Sql IaaS extension Agent.                                            |
| id                                        | core | string     | Resource ID.                                                                                     |
| identity                                  | core | json       | Azure Active Directory identity of the server.                                                   |
| key_vault_credential_settings             | core | json       | Key vault credential settings.                                                                   |
| least_privilege_mode                      | core | string     | SQL IaaS Agent least privilege mode.                                                             |
| location                                  | core | string     | Resource location.                                                                               |
| name                                      | core | string     | Resource name.                                                                                   |
| provisioning_state                        | core | string     | Provisioning state to track the async operation status.                                          |
| resource_group                            | core | string     |
| server_configurations_management_settings | core | json       | SQL Server configuration management settings.                                                    |
| sql_image_offer                           | core | string     | SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.                                |
| sql_image_sku                             | core | string     | SQL Server edition type.                                                                         |
| sql_management                            | core | string     | SQL Server Management type.                                                                      |
| sql_server_license_type                   | core | string     | SQL Server license type.                                                                         |
| sql_virtual_machine_group_resource_id     | core | string     | ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of. |
| storage_configuration_settings            | core | json       | Storage Configuration Settings.                                                                  |
| subscription_id                           | core | string     |
| subscription_name                         | core | string     |
| system_data                               | core | json       |
| tags                                      | core | hstore_csv |
| troubleshooting_status                    | core | json       | Troubleshooting status                                                                           |
| type                                      | core | string     | Resource type.                                                                                   |
| virtual_machine_resource_id               | core | string     | ARM Resource id of underlying virtual machine created from SQL marketplace image.                |
| wsfc_domain_credentials                   | core | json       | Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.    |
| wsfc_static_ip                            | core | string     | Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.    |