Get-AzSqlElasticPoolAdvisor
取得 Azure SQL 彈性集區的一或多個 Advisor。
語法
Get-AzSqlElasticPoolAdvisor
[-AdvisorName <String>]
[-ExpandRecommendedActions]
-ServerName <String>
-ElasticPoolName <String>
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Description
Get-AzSqlElasticPoolAdvisor Cmdlet 會取得一或多個適用於 Azure SQL 彈性集區的 Azure SQL 彈性集區建議程式。
範例
範例 1:列出指定彈性集區的所有建議程式
Get-AzSqlElasticPoolAdvisor -ResourceGroupName "WIRunnersProd" -ServerName "wi-runner-australia-east" -ElasticPoolName "WIRunnerPool"
ElasticPoolName : WIRunnerPool
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 : {}
ElasticPoolName : WIRunnerPool
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 : {}
ElasticPoolName : WIRunnerPool
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 : {}
ElasticPoolName : WIRunnerPool
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 : {}
此命令會列出名為WIRunnerPool之彈性集區的所有建議程式。
範例 2:取得指定彈性集區的單一建議程式
Get-AzSqlElasticPoolAdvisor -ResourceGroupName "WIRunnersProd" -ServerName "wi-runner-australia-east" -ElasticPoolName "WIRunnerPool" -AdvisorName "CreateIndex"
ElasticPoolName : WIRunnerPool
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 : {}
此命令會取得名為WIRunnerPool之彈性集區的 CreateIndex Advisor。
範例 3:列出回應中包含的建議動作的所有顧問
Get-AzSqlElasticPoolAdvisor -ResourceGroupName "WIRunnersProd" -ServerName "wi-runner-australia-east" -ElasticPoolName "WIRunnerPool" -ExpandRecommendedActions
ElasticPoolName : WIRunnerPool
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...}
ElasticPoolName : WIRunnerPool
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...}
ElasticPoolName : WIRunnerPool
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 : {}
ElasticPoolName : WIRunnerPool
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 : {}
此命令會取得彈性集區的所有建議程式,以及回應中包含的建議動作。
範例 4:取得包含於回應中的建議動作的單一建議程式
Get-AzSqlElasticPoolAdvisor -ResourceGroupName "WIRunnersProd" -ServerName "wi-runner-australia-east" -ElasticPoolName "WIRunnerPool" -AdvisorName "CreateIndex" -ExpandRecommendedActions
ElasticPoolName : WIRunnerPool
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...}
此命令會從名為wi-runner-australia-east的伺服器取得名為 CreateIndex 的 Advisor,以及回應中包含的建議動作。
範例 5:使用篩選列出指定彈性集區的所有建議程式
Get-AzSqlElasticPoolAdvisor -ResourceGroupName "WIRunnersProd" -ServerName "wi-runner-australia-east" -ElasticPoolName "WIRunnerPool" -AdvisorName d*
ElasticPoolName : WIRunnerPool
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 : {}
ElasticPoolName : WIRunnerPool
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 : {}
此命令會列出名稱為WIRunnerPool且開頭為字母 「d」 之彈性集區的所有建議程式。
參數
-AdvisorName
指定此 Cmdlet 取得的 Advisor 名稱。
類型: | String |
Position: | Named |
預設值: | None |
必要: | False |
接受管線輸入: | True |
接受萬用字元: | True |
-DefaultProfile
用於與 azure 通訊的認證、帳戶、租用戶和訂用帳戶
類型: | IAzureContextContainer |
別名: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
預設值: | None |
必要: | False |
接受管線輸入: | False |
接受萬用字元: | False |
-ElasticPoolName
指定此 Cmdlet 要求 Advisor 的彈性集區名稱。
類型: | String |
Position: | Named |
預設值: | None |
必要: | True |
接受管線輸入: | True |
接受萬用字元: | False |
-ExpandRecommendedActions
指出 Cmdlet 在回應中包含 Advisor 的建議動作。
類型: | SwitchParameter |
Position: | Named |
預設值: | None |
必要: | False |
接受管線輸入: | True |
接受萬用字元: | False |
-ResourceGroupName
指定包含此彈性集區之伺服器的資源群組名稱。
類型: | String |
Position: | 0 |
預設值: | None |
必要: | True |
接受管線輸入: | True |
接受萬用字元: | False |
-ServerName
指定彈性集區位於的伺服器名稱。
類型: | String |
Position: | Named |
預設值: | None |
必要: | True |
接受管線輸入: | True |
接受萬用字元: | False |
輸入
輸出
AzureSqlElasticPoolAdvisorModel
備註
- 關鍵詞:azure、azurerm、arm、resource、management、manager、sql、elasticpool、mssql、advisor
相關連結
意見反應
https://aka.ms/ContentUserFeedback。
即將登場:在 2024 年,我們將逐步淘汰 GitHub 問題作為內容的意見反應機制,並將它取代為新的意見反應系統。 如需詳細資訊,請參閱:提交並檢視相關的意見反應