Set-AzureRmSqlServerRecommendedActionState

NAME Set-AzureRmSqlServerRecommendedActionState



SYNOPSIS

Updates the state of an Azure SQL Server recommended action.





SYNTAX

Set-AzureRmSqlServerRecommendedActionState [-ResourceGroupName] <String> -AdvisorName <String> [-DefaultProfile <IAzureContextContainer>]

-RecommendedActionName <String> -ServerName <String> -State {Active | Pending | PendingRevert | RevertCancelled | Ignored | Resolved} [-Confirm]

[-WhatIf] [<CommonParameters>]





DESCRIPTION

The Set-AzureRmSqlServerRecommendedActionState cmdlet updates state of an Azure SQL Server recommended action. This cmdlet applies, reverts, or

discards the recommended action based on the new state.





PARAMETERS

-AdvisorName <String>

Specifies the name of the advisor that contains the recommended action.



Required? true

Position? named

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-DefaultProfile <IAzureContextContainer>

The credentials, account, tenant, and subscription used for communication with azure



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-RecommendedActionName <String>

Specifies the name of the recommended action for which this cmdlet updates the state.



Required? true

Position? named

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ResourceGroupName <String>

Specifies the name of the resource group of the server.



Required? true

Position? 0

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ServerName <String>

Specifies the name of the server.



Required? true

Position? named

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-State <RecommendedActionState>

Specifies the new value to which this cmdlet updates the recommended action state.



The acceptable values for this parameter are:



- Active



- Pending



- PendingRevert



- RevertCancelled



- Ignored



- Resolved



Required? true

Position? named

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-Confirm [<SwitchParameter>]

Prompts you for confirmation before running the cmdlet.



Required? false

Position? named

Default value False

Accept pipeline input? False

Accept wildcard characters? false



-WhatIf [<SwitchParameter>]

Shows what would happen if the cmdlet runs. The cmdlet is not run.



Required? false

Position? named

Default value False

Accept pipeline input? False

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).



INPUTS

None

This cmdlet does not accept any input.





OUTPUTS

Microsoft.Azure.Commands.Sql.RecommendedAction.Model.AzureSqlServerRecommendedActionModel







NOTES





* Keywords: azure, azurerm, arm, resource, management, manager, sql, server, mssql, advisor, recommendedaction



Example1: Update the state of the specified recommended action to Pending



PS C:\\>Set-AzureRmSqlServerRecommendedActionState -ResourceGroupName "WIRunnersProd" -ServerName "wi-runner-australia-east" -AdvisorName

"CreateIndex" -RecommendedActionName "IR_[test_schema]_[test_table_0.0361551]_6C7AE8CC9C87E7FD5893" -State Pending

ResourceGroupName : WIRunnersProd

ServerName : wi-runner-australia-east

AdvisorName : CreateIndex

RecommendedActionName : IR_[test_schema]_[test_table_0.0361551]_6C7AE8CC9C87E7FD5893

Details : {[indexName, nci_wi_test_table_0.0361551_6C7AE8CC9C87E7FD5893], [indexType,

NONCLUSTERED], [schema, [test_schema]], [table, [test_table_0.0361551]]...}

ErrorDetails : Microsoft.Azure.Management.Sql.Models.RecommendedActionErrorInfo

EstimatedImpact : {ActionDuration, SpaceChange}

ExecuteActionDuration : PT1M

ExecuteActionInitiatedBy : User

ExecuteActionInitiatedTime : 4/21/2016 3:24:47 PM

ExecuteActionStartTime : 4/21/2016 3:24:47 PM

ImplementationDetails : Microsoft.Azure.Management.Sql.Models.RecommendedActionImplementationInfo

IsArchivedAction : False

IsExecutableAction : True

IsRevertableAction : True

LastRefresh : 4/21/2016 3:24:47 PM

LinkedObjects : {}

ObservedImpact : {CpuUtilization, LogicalReads, LogicalWrites, QueriesWithImprovedPerformance...}

RecommendationReason :

RevertActionDuration :

RevertActionInitiatedBy :

RevertActionInitiatedTime :

RevertActionStartTime :

Score : 2

State : Microsoft.Azure.Management.Sql.Models.RecommendedActionStateInfo

TimeSeries : {}

ValidSince : 4/21/2016 3:24:47 PM



Updates state of server recommended action named "IR_[test_schema]_[test_table_0.0361551]_6C7AE8CC9C87E7FD5893" to "Pending"







RELATED LINKS

Online Version: https://docs.microsoft.com/en-us/powers ... ctionstate

Get-AzureRmSqlServerAdvisor

Get-AzureRmSqlServerRecommendedAction

Set-AzureRmSqlDatabaseRecommendedActionState

Set-AzureRmSqlElasticPoolRecommendedActionState

SQL Database Documentation https://docs.microsoft.com/azure/sql-database/