server_automatic_tunings
Creates, updates, deletes, gets or lists a server_automatic_tunings resource.
Overview
| Name | server_automatic_tunings |
| Type | Resource |
| Id | azure.sql.server_automatic_tunings |
Fields
The following fields are returned by SELECT queries:
- get
Successfully retrieved server automatic tuning properties.
| Name | Datatype | Description |
|---|---|---|
properties | object | Resource properties. |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | resourceGroupName, serverName, subscriptionId | Retrieves server automatic tuning options. | |
update | update | resourceGroupName, serverName, subscriptionId | Update automatic tuning options on server. |
Parameters
Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.
| Name | Datatype | Description |
|---|---|---|
resourceGroupName | string | The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal. |
serverName | string | The name of the server. |
subscriptionId | string | The subscription ID that identifies an Azure subscription. |
SELECT examples
- get
Retrieves server automatic tuning options.
SELECT
properties
FROM azure.sql.server_automatic_tunings
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND serverName = '{{ serverName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;
UPDATE examples
- update
Update automatic tuning options on server.
UPDATE azure.sql.server_automatic_tunings
SET
data__properties = '{{ properties }}'
WHERE
resourceGroupName = '{{ resourceGroupName }}' --required
AND serverName = '{{ serverName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
RETURNING
properties;