database_automatic_tunings

Creates, updates, deletes, gets or lists a database_automatic_tunings resource.

Overview

Name	database_automatic_tunings
Type	Resource
Id	azure.sql.database_automatic_tunings

Fields

vw_database_automatic_tunings

Name	Datatype	Description
actual_state	text	field from the properties object
databaseName	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

database_automatic_tunings

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

Methods

Name	Accessible by	Required Params	Description
get	SELECT	databaseName, resourceGroupName, serverName, subscriptionId	Gets a database's automatic tuning.
update	UPDATE	databaseName, resourceGroupName, serverName, subscriptionId	Update automatic tuning properties for target database.

SELECT examples

Gets a database's automatic tuning.

vw_database_automatic_tunings

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

database_automatic_tunings

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

UPDATE example

Updates a database_automatic_tunings resource.

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