< Back
Stop-AzureRmSqlDatabaseExecuteIndexRecommendation
Post
NAME Stop-AzureRmSqlDatabaseExecuteIndexRecommendation
SYNOPSIS
Stops the workflow that runs a recommended index operation.
SYNTAX
Stop-AzureRmSqlDatabaseExecuteIndexRecommendation [-ResourceGroupName] <String> -DatabaseName <String> [-DefaultProfile <IAzureContextContainer>]
-IndexRecommendationName <String> -ServerName <String> [<CommonParameters>]
DESCRIPTION
The Stop-AzureRmSqlDatabaseExecuteIndexRecommendation cmdlet stops the workflow that runs a recommended index operation.
PARAMETERS
-DatabaseName <String>
Specifies the name of the database for which this cmdlet stops 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 stops.
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 stops 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: Stop running an index recommendation
PS C:\\>Stop-AzureRmSqlDatabaseExecuteIndexRecommendation -ResourceGroup "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01"
-IndexRecommendationName "INDEX_NAME"
This command stops running an index recommendation.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... mmendation
Get-AzureRmSqlDatabaseIndexRecommendations
Start-AzureRmSqlDatabaseExecuteIndexRecommendation
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/
SYNOPSIS
Stops the workflow that runs a recommended index operation.
SYNTAX
Stop-AzureRmSqlDatabaseExecuteIndexRecommendation [-ResourceGroupName] <String> -DatabaseName <String> [-DefaultProfile <IAzureContextContainer>]
-IndexRecommendationName <String> -ServerName <String> [<CommonParameters>]
DESCRIPTION
The Stop-AzureRmSqlDatabaseExecuteIndexRecommendation cmdlet stops the workflow that runs a recommended index operation.
PARAMETERS
-DatabaseName <String>
Specifies the name of the database for which this cmdlet stops 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 stops.
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 stops 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: Stop running an index recommendation
PS C:\\>Stop-AzureRmSqlDatabaseExecuteIndexRecommendation -ResourceGroup "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01"
-IndexRecommendationName "INDEX_NAME"
This command stops running an index recommendation.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... mmendation
Get-AzureRmSqlDatabaseIndexRecommendations
Start-AzureRmSqlDatabaseExecuteIndexRecommendation
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/