Get-AzSqlDatabaseAdvisor
Gets one or more Advisors for an Azure SQL Database.
Syntax
Default (Default)
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.
Parameter properties
Type: | String |
Default value: | None |
Supports wildcards: | True |
DontShow: | False |
Parameter sets
(All)
Position: | Named |
Mandatory: | False |
Value from pipeline: | False |
Value from pipeline by property name: | True |
Value from remaining arguments: | False |
-DatabaseName
Specifies the name of the database for which this cmdlet requests the Advisor.
Parameter properties
Type: | String |
Default value: | None |
Supports wildcards: | False |
DontShow: | False |
Parameter sets
(All)
Position: | Named |
Mandatory: | True |
Value from pipeline: | False |
Value from pipeline by property name: | True |
Value from remaining arguments: | False |
-DefaultProfile
The credentials, account, tenant, and subscription used for communication with azure
Parameter properties
Type: | IAzureContextContainer |
Default value: | None |
Supports wildcards: | False |
DontShow: | False |
Aliases: | AzContext, AzureRmContext, AzureCredential |
Parameter sets
(All)
Position: | Named |
Mandatory: | False |
Value from pipeline: | False |
Value from pipeline by property name: | False |
Value from remaining arguments: | False |
-ExpandRecommendedActions
Indicates that this cmdlet gets the recommended actions with the response.
Parameter properties
Type: | SwitchParameter |
Default value: | None |
Supports wildcards: | False |
DontShow: | False |
Parameter sets
(All)
Position: | Named |
Mandatory: | False |
Value from pipeline: | False |
Value from pipeline by property name: | True |
Value from remaining arguments: | False |
-ResourceGroupName
Specifies the name of the resource group of the server that contains this database.
Parameter properties
Type: | String |
Default value: | None |
Supports wildcards: | False |
DontShow: | False |
Parameter sets
(All)
Position: | 0 |
Mandatory: | True |
Value from pipeline: | False |
Value from pipeline by property name: | True |
Value from remaining arguments: | False |
-ServerName
Specifies the name of the server that contains the database.
Parameter properties
Type: | String |
Default value: | None |
Supports wildcards: | False |
DontShow: | False |
Parameter sets
(All)
Position: | Named |
Mandatory: | True |
Value from pipeline: | False |
Value from pipeline by property name: | True |
Value from remaining arguments: | False |
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
Inputs
String
SwitchParameter
Outputs
AzureSqlDatabaseAdvisorModel
Notes
- Keywords: azure, azurerm, arm, resource, management, manager, sql, database, mssql, advisor