< Back
Get-AzureRmSqlDatabaseAdvisor
Post
NAME Get-AzureRmSqlDatabaseAdvisor
SYNOPSIS
Gets one or more Advisors for an Azure SQL Database.
SYNTAX
Get-AzureRmSqlDatabaseAdvisor [-ResourceGroupName] <String> [-AdvisorName <String>] -DatabaseName <String> [-DefaultProfile
<IAzureContextContainer>] [-ExpandRecommendedActions] -ServerName <String> [<CommonParameters>]
DESCRIPTION
The Get-AzureRmSqlDatabaseAdvisor cmdlet gets one or more Azure SQL Database Advisors for an Azure SQL Database.
PARAMETERS
-AdvisorName <String>
Specifies the name of the advisor that this cmdlet gets.
Required? false
Position? named
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-DatabaseName <String>
Specifies the name of the database for which this cmdlet requests the Advisor.
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
-ExpandRecommendedActions [<SwitchParameter>]
Indicates that this cmdlet gets the recommended actions with the response.
Required? false
Position? named
Default value False
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ResourceGroupName <String>
Specifies the name of the resource group of the server that contains this database.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerName <String>
Specifies the name of the server that contains the database.
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
Microsoft.Azure.Commands.Sql.Advisor.Model.AzureSqlDatabaseAdvisorModel
NOTES
* Keywords: azure, azurerm, arm, resource, management, manager, sql, database, mssql, advisor
Example 1: List all the advisors for the specified database
PS C:\\>Get-AzureRmSqlDatabaseAdvisor -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
PS C:\\>Get-AzureRmSqlDatabaseAdvisor -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
PS C:\\>Get-AzureRmSqlDatabaseAdvisor -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
PS C:\\>Get-AzureRmSqlDatabaseAdvisor -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.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... aseadvisor
Get-AzureRmSqlServerAdvisor
Get-AzureRmSqlElasticPoolAdvisor
Get-AzureRmSqlDatabaseRecommendedAction
Set-AzureRmSqlDatabaseAdvisorAutoExecuteStatus
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/
SYNOPSIS
Gets one or more Advisors for an Azure SQL Database.
SYNTAX
Get-AzureRmSqlDatabaseAdvisor [-ResourceGroupName] <String> [-AdvisorName <String>] -DatabaseName <String> [-DefaultProfile
<IAzureContextContainer>] [-ExpandRecommendedActions] -ServerName <String> [<CommonParameters>]
DESCRIPTION
The Get-AzureRmSqlDatabaseAdvisor cmdlet gets one or more Azure SQL Database Advisors for an Azure SQL Database.
PARAMETERS
-AdvisorName <String>
Specifies the name of the advisor that this cmdlet gets.
Required? false
Position? named
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-DatabaseName <String>
Specifies the name of the database for which this cmdlet requests the Advisor.
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
-ExpandRecommendedActions [<SwitchParameter>]
Indicates that this cmdlet gets the recommended actions with the response.
Required? false
Position? named
Default value False
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ResourceGroupName <String>
Specifies the name of the resource group of the server that contains this database.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerName <String>
Specifies the name of the server that contains the database.
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
Microsoft.Azure.Commands.Sql.Advisor.Model.AzureSqlDatabaseAdvisorModel
NOTES
* Keywords: azure, azurerm, arm, resource, management, manager, sql, database, mssql, advisor
Example 1: List all the advisors for the specified database
PS C:\\>Get-AzureRmSqlDatabaseAdvisor -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
PS C:\\>Get-AzureRmSqlDatabaseAdvisor -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
PS C:\\>Get-AzureRmSqlDatabaseAdvisor -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
PS C:\\>Get-AzureRmSqlDatabaseAdvisor -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.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... aseadvisor
Get-AzureRmSqlServerAdvisor
Get-AzureRmSqlElasticPoolAdvisor
Get-AzureRmSqlDatabaseRecommendedAction
Set-AzureRmSqlDatabaseAdvisorAutoExecuteStatus
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/