database_recommended_actions

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

Overview

Name	database_recommended_actions
Type	Resource
Id	azure.sql.database_recommended_actions

Fields

vw_database_recommended_actions

Name	Datatype	Description
advisorName	text	field from the properties object
databaseName	text	field from the properties object
details	text	field from the properties object
error_details	text	field from the properties object
estimated_impact	text	field from the properties object
execute_action_duration	text	field from the properties object
execute_action_initiated_by	text	field from the properties object
execute_action_initiated_time	text	field from the properties object
execute_action_start_time	text	field from the properties object
implementation_details	text	field from the properties object
is_archived_action	text	field from the properties object
is_executable_action	text	field from the properties object
is_revertable_action	text	field from the properties object
kind	text	Resource kind.
last_refresh	text	field from the properties object
linked_objects	text	field from the properties object
location	text	Resource location.
observed_impact	text	field from the properties object
recommendation_reason	text	field from the properties object
recommendedActionName	text	field from the properties object
resourceGroupName	text	field from the properties object
revert_action_duration	text	field from the properties object
revert_action_initiated_by	text	field from the properties object
revert_action_initiated_time	text	field from the properties object
revert_action_start_time	text	field from the properties object
score	text	field from the properties object
serverName	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object
time_series	text	field from the properties object
valid_since	text	field from the properties object

database_recommended_actions

Name	Datatype	Description
kind	string	Resource kind.
location	string	Resource location.
properties	object	Properties for a Database, Server or Elastic Pool Recommended Action.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	advisorName, databaseName, recommendedActionName, resourceGroupName, serverName, subscriptionId	Gets a database recommended action.
update	UPDATE	advisorName, databaseName, recommendedActionName, resourceGroupName, serverName, subscriptionId	Updates a database recommended action.
list_by_database_advisor	EXEC	advisorName, databaseName, resourceGroupName, serverName, subscriptionId	Gets list of Database Recommended Actions.

SELECT examples

Gets a database recommended action.

vw_database_recommended_actions

SELECT
advisorName,
databaseName,
details,
error_details,
estimated_impact,
execute_action_duration,
execute_action_initiated_by,
execute_action_initiated_time,
execute_action_start_time,
implementation_details,
is_archived_action,
is_executable_action,
is_revertable_action,
kind,
last_refresh,
linked_objects,
location,
observed_impact,
recommendation_reason,
recommendedActionName,
resourceGroupName,
revert_action_duration,
revert_action_initiated_by,
revert_action_initiated_time,
revert_action_start_time,
score,
serverName,
state,
subscriptionId,
time_series,
valid_since
FROM azure.sql.vw_database_recommended_actions
WHERE advisorName = '{{ advisorName }}'
AND databaseName = '{{ databaseName }}'
AND recommendedActionName = '{{ recommendedActionName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

database_recommended_actions

SELECT
kind,
location,
properties
FROM azure.sql.database_recommended_actions
WHERE advisorName = '{{ advisorName }}'
AND databaseName = '{{ databaseName }}'
AND recommendedActionName = '{{ recommendedActionName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

UPDATE example

Updates a database_recommended_actions resource.

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