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

vw_server_automatic_tunings

Name	Datatype	Description
actual_state	text	field from the properties object
desired_state	text	field from the properties object
options	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
subscriptionId	text	field from the properties object

server_automatic_tunings

Name	Datatype	Description
properties	object	Server-level Automatic Tuning properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, serverName, subscriptionId	Retrieves server automatic tuning options.
update	UPDATE	resourceGroupName, serverName, subscriptionId	Update automatic tuning options on server.

SELECT examples

Retrieves server automatic tuning options.

vw_server_automatic_tunings

SELECT
actual_state,
desired_state,
options,
resourceGroupName,
serverName,
subscriptionId
FROM azure.sql.vw_server_automatic_tunings
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

server_automatic_tunings

SELECT
properties
FROM azure.sql.server_automatic_tunings
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

UPDATE example

Updates a server_automatic_tunings resource.

/*+ update */
UPDATE azure.sql.server_automatic_tunings
SET 
properties = '{{ properties }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';