Set-AzureRmSqlElasticPoolRecommendedActionState

NAME Set-AzureRmSqlElasticPoolRecommendedActionState



SYNOPSIS

Updates the state of an Azure SQL Elastic Pool recommended action.





SYNTAX

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

-ElasticPoolName <String> -RecommendedActionName <String> -ServerName <String> -State {Active | Pending | PendingRevert | RevertCancelled |

Ignored | Resolved} [-Confirm] [-WhatIf] [<CommonParameters>]





DESCRIPTION

The Set-AzureRmSqlElasticPoolRecommendedActionState cmdlet updates state of an Azure SQL Elastic Pool recommended action. This cmdlet applies an

recommended action, reverted, or discarded based on the new state.





PARAMETERS

-AdvisorName <String>

Specifies the name of the advisor for which this recommended action belongs to.



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



-ElasticPoolName <String>

Specifies name of the elastic pool.



Required? true

Position? named

Default value None

Accept pipeline input? True (ByPropertyName)

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 that contains this elastic pool.



Required? true

Position? 0

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ServerName <String>

Specifies the name of the server the elastic pool is in.



Required? true

Position? named

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-State <RecommendedActionState>

Specifies the 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



NOTES





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



Example 1: Update the state of a recommended action to Pending



PS C:\\>Set-AzureRmSqlElasticPoolRecommendedActionState -ResourceGroupName "WIRunnersProd" -ServerName "wi-runner-australia-east" -ElasticPoolName

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

ElasticPoolName : WIRunnerPool

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



This command updates the state of elastic pool 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-AzureRmSqlElasticPoolRecommendedAction

Set-AzureRmSqlDatabaseRecommendedActionState

Set-AzureRmSqlServerRecommendedActionState

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