< Back

Get-AzureRmSqlServerRecommendedAction

Tue Jan 29, 2019 10:09 pm

NAME Get-AzureRmSqlServerRecommendedAction



SYNOPSIS

Gets one or more recommended actions for an Azure SQL Server Advisor.





SYNTAX

Get-AzureRmSqlServerRecommendedAction [-ResourceGroupName] <String> -AdvisorName <String> [-DefaultProfile <IAzureContextContainer>]

[-RecommendedActionName <String>] -ServerName <String> [<CommonParameters>]





DESCRIPTION

The Get-AzureRmSqlServerRecommendedAction cmdlet gets one or more recommended actions for an Azure SQL Server Advisor.





PARAMETERS

-AdvisorName <String>

Specifies the name of the advisor for which this cmdlet requests actions.



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 that this cmdlet gets.



Required? false

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 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 the Advisor belongs to.



Required? true

Position? named

Default value None

Accept pipeline input? True (ByPropertyName)

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



Example 1: Get a list of all recommended actions for a specific Advisor



PS C:\\>Get-AzureRmSqlServerRecommendedAction -ResourceGroupName "WIRunnersProd" -ServerName "wi-runner-australia-east" -AdvisorName "CreateIndex"

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



ResourceGroupName : WIRunnersProd

ServerName : wi-runner-australia-east

AdvisorName : CreateIndex

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

Details : {[indexName, nci_wi_test_table_0.236046_6C7AE8CC9C87E7FD5893], [indexType, NONCLUSTERED],

[schema, [test_schema]], [table, [test_table_0.236046]]...}

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 : {SpaceChange}

RecommendationReason :

RevertActionDuration :

RevertActionInitiatedBy :

RevertActionInitiatedTime :

RevertActionStartTime :

Score : 3

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

TimeSeries : {}

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



ResourceGroupName : WIRunnersProd

ServerName : wi-runner-australia-east

AdvisorName : CreateIndex

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

Details : {[indexName, nci_wi_test_table_0.239359_6C7AE8CC9C87E7FD5893], [indexType, NONCLUSTERED],

[schema, [test_schema]], [table, [test_table_0.239359]]...}

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 : PT10S

RevertActionInitiatedBy : System

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

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

Score : 3

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

TimeSeries : {}

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



This command gets a list of all recommended actions of for the SQL Server Advisor named CreateIndex available for the server named

wi-runner-australia-east.





Example 2: Get a single recommended action for an Advisor



PS C:\\>Get-AzureRmSqlServerRecommendedAction -ResourceGroupName "WIRunnersProd" -ServerName "wi-runner-australia-east" -AdvisorName "CreateIndex"

-RecommendedActionName

IR_[test_schema]_[test_table_0.0361551]_6C7AE8CC9C87E7FD5893

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 gets a recommended action named IR_[test_schema]_[test_table_0.0361551]_6C7AE8CC9C87E7FD5893 from the Advisor named CreateIndex.







RELATED LINKS

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

Get-AzureRmSqlServerAdvisor

Set-AzureRmSqlServerRecommendedActionState

Get-AzureRmSqlElasticPoolRecommendedAction

Get-AzureRmSqlDatabaseRecommendedAction

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