Start-AzureRmSqlDatabaseExecuteIndexRecommendation

NAME Start-AzureRmSqlDatabaseExecuteIndexRecommendation



SYNOPSIS

Starts the workflow that runs a recommended index operation.





SYNTAX

Start-AzureRmSqlDatabaseExecuteIndexRecommendation [-ResourceGroupName] <String> -DatabaseName <String> [-DefaultProfile <IAzureContextContainer>]

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





DESCRIPTION

The Start-AzureRmSqlDatabaseExecuteIndexRecommendation cmdlet starts the workflow that runs a recommended index operation for an Azure SQL

Database.





PARAMETERS

-DatabaseName <String>

Specifies the name of the database for which this cmdlet starts the workflow.



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



-IndexRecommendationName <String>

Specifies the name of the index recommendation that this cmdlet runs.



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 to which the server is assigned.



Required? true

Position? 0

Default value None

Accept pipeline input? True (ByPropertyName)

Accept wildcard characters? false



-ServerName <String>

Specifies the server that hosts the database for which this cmdlet starts a workflow.



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



NOTES









Example 1: Run an index recommendation



PS C:\\>Start-AzureRmSqlDatabaseExecuteIndexRecommendation -ResourceGroup "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01"

-IndexRecommendationName "INDEX_NAME"



This command runs an index recommendation.







RELATED LINKS

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

Get-AzureRmSqlDatabaseIndexRecommendations

Stop-AzureRmSqlDatabaseExecuteIndexRecommendation

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