Get-AzSqlDatabaseAdvisor
Gets one or more Advisors for an Azure SQL Database.
Syntax
Get-AzSqlDatabaseAdvisor
[-AdvisorName <String>]
[-ExpandRecommendedActions]
-ServerName <String>
-DatabaseName <String>
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>] Description
The Get-AzSqlDatabaseAdvisor cmdlet gets one or more Azure SQL Database Advisors for an Azure SQL Database.
Examples
Example 1: List all the advisors for the specified database
Get-AzSqlDatabaseAdvisor -ResourceGroupName "WIRunnersProd" -ServerName "wi-runner-australia-east" -DatabaseName "WIRunner"
DatabaseName : WIRunner
ResourceGroupName : WIRunnersProd
ServerName : wi-runner-australia-east
AdvisorName : CreateIndex
AdvisorStatus : GA
AutoExecuteStatus : Disabled
AutoExecuteStatusInheritedFrom : Database
LastChecked : 8/1/2016 2:36:47 PM
RecommendationsStatus : Ok
RecommendedActions : {}
DatabaseName : WIRunner
ResourceGroupName : WIRunnersProd
ServerName : wi-runner-australia-east
AdvisorName : DropIndex
AdvisorStatus : PublicPreview
AutoExecuteStatus : Disabled
AutoExecuteStatusInheritedFrom : Database
LastChecked : 7/31/2016 8:41:19 PM
RecommendationsStatus : Ok
RecommendedActions : {}
DatabaseName : WIRunner
ResourceGroupName : WIRunnersProd
ServerName : wi-runner-australia-east
AdvisorName : DbParameterization
AdvisorStatus : PublicPreview
AutoExecuteStatus : Disabled
AutoExecuteStatusInheritedFrom : Default
LastChecked : 7/31/2016 2:46:58 PM
RecommendationsStatus : NoDbParameterizationIssue
RecommendedActions : {}
DatabaseName : WIRunner
ResourceGroupName : WIRunnersProd
ServerName : wi-runner-australia-east
AdvisorName : SchemaIssue
AdvisorStatus : PublicPreview
AutoExecuteStatus : Disabled
AutoExecuteStatusInheritedFrom : Default
LastChecked : 8/1/2016 3:01:41 PM
RecommendationsStatus : SchemaIsConsistent
RecommendedActions : {}This command gets lists all the advisors for the database named WIRunner that belongs to the server named wi-runner-australia-east.
Example 2: Get a single advisor for the specified database
Get-AzSqlDatabaseAdvisor -ResourceGroupName "WIRunnersProd" -ServerName "wi-runner-australia-east" -DatabaseName "WIRunner" -AdvisorName "CreateIndex"
DatabaseName : WIRunner
ResourceGroupName : WIRunnersProd
ServerName : wi-runner-australia-east
AdvisorName : CreateIndex
AdvisorStatus : GA
AutoExecuteStatus : Disabled
AutoExecuteStatusInheritedFrom : Database
LastChecked : 8/1/2016 2:36:47 PM
RecommendationsStatus : Ok
RecommendedActions : {}This command gets the Advisor named CreateIndex for the database named WIRunner.
Example 3: List all the advisors with their recommended actions included in the response
Get-AzSqlDatabaseAdvisor -ResourceGroupName "WIRunnersProd" -ServerName "wi-runner-australia-east" -DatabaseName "WIRunner" -ExpandRecommendedActions
DatabaseName : WIRunner
ResourceGroupName : WIRunnersProd
ServerName : wi-runner-australia-east
AdvisorName : CreateIndex
AdvisorStatus : GA
AutoExecuteStatus : Disabled
AutoExecuteStatusInheritedFrom : Database
LastChecked : 8/1/2016 2:36:47 PM
RecommendationsStatus : Ok
RecommendedActions : {IR_[test_schema]_[test_table_0.0361551]_6C7AE8CC9C87E7FD5893,
IR_[test_schema]_[test_table_0.236046]_6C7AE8CC9C87E7FD5893,
IR_[test_schema]_[test_table_0.239359]_6C7AE8CC9C87E7FD5893,
IR_[test_schema]_[test_table_0.437714]_6C7AE8CC9C87E7FD5893...}
DatabaseName : WIRunner
ResourceGroupName : WIRunnersProd
ServerName : wi-runner-australia-east
AdvisorName : DropIndex
AdvisorStatus : PublicPreview
AutoExecuteStatus : Disabled
AutoExecuteStatusInheritedFrom : Database
LastChecked : 7/31/2016 8:41:19 PM
RecommendationsStatus : Ok
RecommendedActions : {IR_[test_schema]_[test_table_0.0288891]_38724E1DCF2178318957,
IR_[test_schema]_[test_table_0.140264]_38724E1DCF2178318957,
IR_[test_schema]_[test_table_0.412191]_38724E1DCF2178318957,
IR_[test_schema]_[test_table_0.442075]_38724E1DCF2178318957...}
DatabaseName : WIRunner
ResourceGroupName : WIRunnersProd
ServerName : wi-runner-australia-east
AdvisorName : DbParameterization
AdvisorStatus : PublicPreview
AutoExecuteStatus : Disabled
AutoExecuteStatusInheritedFrom : Default
LastChecked : 7/31/2016 2:46:58 PM
RecommendationsStatus : NoDbParameterizationIssue
RecommendedActions : {}
DatabaseName : WIRunner
ResourceGroupName : WIRunnersProd
ServerName : wi-runner-australia-east
AdvisorName : SchemaIssue
AdvisorStatus : PublicPreview
AutoExecuteStatus : Disabled
AutoExecuteStatusInheritedFrom : Default
LastChecked : 8/1/2016 3:04:26 PM
RecommendationsStatus : SchemaIsConsistent
RecommendedActions : {}This command gets all the advisors for the database named 'WIRunner' with their recommended actions included in the response. Since the command uses the ExpandRecommendedActions parameter, the cmdlet gets the recommended actions with the response.
Example 4: Get a single advisor with its recommended actions included in the response
Get-AzSqlDatabaseAdvisor -ResourceGroupName "WIRunnersProd" -ServerName "wi-runner-australia-east" -DatabaseName "WIRunner" -AdvisorName "CreateIndex" -ExpandRecommendedActions
DatabaseName : WIRunner
ResourceGroupName : WIRunnersProd
ServerName : wi-runner-australia-east
AdvisorName : CreateIndex
AdvisorStatus : GA
AutoExecuteStatus : Disabled
AutoExecuteStatusInheritedFrom : Database
LastChecked : 8/1/2016 2:36:47 PM
RecommendationsStatus : Ok
RecommendedActions : {IR_[test_schema]_[test_table_0.0361551]_6C7AE8CC9C87E7FD5893,
IR_[test_schema]_[test_table_0.236046]_6C7AE8CC9C87E7FD5893,
IR_[test_schema]_[test_table_0.239359]_6C7AE8CC9C87E7FD5893,
IR_[test_schema]_[test_table_0.437714]_6C7AE8CC9C87E7FD5893...}This command gets the Advisor named CreateIndex from the database named WIRunner with its recommended actions included in the response. Since the command uses the ExpandRecommendedActions parameter, the cmdlet gets the recommended actions with the response.
Example 5: List all the advisors for the specified database using filtering
Get-AzSqlDatabaseAdvisor -ResourceGroupName "WIRunnersProd" -ServerName "wi-runner-australia-east" -DatabaseName "WIRunner" -AdvisorName d*
DatabaseName : WIRunner
ResourceGroupName : WIRunnersProd
ServerName : wi-runner-australia-east
AdvisorName : DropIndex
AdvisorStatus : PublicPreview
AutoExecuteStatus : Disabled
AutoExecuteStatusInheritedFrom : Database
LastChecked : 7/31/2016 8:41:19 PM
RecommendationsStatus : Ok
RecommendedActions : {}
DatabaseName : WIRunner
ResourceGroupName : WIRunnersProd
ServerName : wi-runner-australia-east
AdvisorName : DbParameterization
AdvisorStatus : PublicPreview
AutoExecuteStatus : Disabled
AutoExecuteStatusInheritedFrom : Default
LastChecked : 7/31/2016 2:46:58 PM
RecommendationsStatus : NoDbParameterizationIssue
RecommendedActions : {}This command gets lists all the advisors for the database named WIRunner that belongs to the server named wi-runner-australia-east and start with the letter "d".
Parameters
-AdvisorName
Specifies the name of the advisor that this cmdlet gets.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | True |
-DatabaseName
Specifies the name of the database for which this cmdlet requests the Advisor.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-DefaultProfile
The credentials, account, tenant, and subscription used for communication with azure
| Type: | IAzureContextContainer |
| Aliases: | AzContext, AzureRmContext, AzureCredential |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ExpandRecommendedActions
Indicates that this cmdlet gets the recommended actions with the response.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-ResourceGroupName
Specifies the name of the resource group of the server that contains this database.
| Type: | String |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-ServerName
Specifies the name of the server that contains the database.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
Inputs
Outputs
Notes
- Keywords: azure, azurerm, arm, resource, management, manager, sql, database, mssql, advisor
Related Links
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
Azure PowerShell
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for