Stop-AzSqlDatabaseExecuteIndexRecommendation
Stops the workflow that runs a recommended index operation.
Note
This is the previous version of our documentation. Please consult the most recent version for up-to-date information.
Syntax
Stop-AzSqlDatabaseExecuteIndexRecommendation
-ServerName <String>
-DatabaseName <String>
-IndexRecommendationName <String>
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Description
The Stop-AzSqlDatabaseExecuteIndexRecommendation cmdlet stops the workflow that runs a recommended index operation.
Examples
Example 1: Stop running an index recommendation
PS C:\>Stop-AzSqlDatabaseExecuteIndexRecommendation -ResourceGroup "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01" -IndexRecommendationName "INDEX_NAME"
This command stops running an index recommendation.
Parameters
Specifies the name of the database for which this cmdlet stops the workflow.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
The credentials, account, tenant, and subscription used for communication with azure
| Type: | IAzureContextContainer |
| Aliases: | AzContext, AzureRmContext, AzureCredential |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Specifies the name of the index recommendation that this cmdlet stops.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
Specifies the name of the resource group to which the server is assigned.
| Type: | String |
| Position: | 0 |
| Default value: | None |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
Specifies the server that hosts the database for which this cmdlet stops a workflow.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |