適用於：
SQL Server
移轉儀錶板是一個方便的檢視，可顯示 Azure Arc 啟用的所有 SQL Server 實例及其移轉整備程度。 由 Azure Arc 啟用的 SQL Server 會自動產生移轉至 Azure 的評量。 此評量在雲端移轉和現代化旅程的成功中扮演著重要角色。 使用此儀錶板，您可以大規模追蹤移轉旅程。 整備程度會以屬性的形式投影到 Azure 管理平面中，以允許使用 Azure 原生的組織、標記和查詢功能。
儀錶板提供：
- 探索到的 SQL Server 實例和資料庫概觀。
- SQL Server 實例的概觀，附帶生成的評估。
- 每個 Azure SQL 供應專案的移轉整備摘要。
- 豐富的篩選功能，可用來根據您的需求量身打造檢視。
審核遷移評估
您可以透過下列方式存取移轉儀表板：
- 在 Azure 入口網站中，搜尋 Azure Arc 並移至 Azure Arc 中心。
- 在左窗格中，展開 [資料服務 ]，然後移至 [SQL Server 執行個體]。
- 選取 [移轉儀表板 ] 索引標籤。
探索到的 SQL Server 實例和資料庫的摘要
儀表板的第一部分提供您可以存取的所有 SQL Server 執行個體和資料庫的概觀。 您還可以查看依版本和版本類型的實例分佈。
SQL Server 移轉評估摘要
儀錶板的本節提供 Azure Arc 所啟用 SQL Server 實例的移轉評量和移轉整備程度概觀。您可以看到有多少實例有可用的評量。 每個 Azure SQL 供應專案的移轉整備程度會個別顯示。
Azure Resource Graph 查詢
Azure Resource Graph 提供有效率且高效能的方法，可查詢 Azure Arc 所啟用 SQL Server 實例的整備屬性。以下是一些範例查詢。
resources
| where type == 'microsoft.azurearcdata/sqlserverinstances'
| where properties.migration.assessment.assessmentUploadTime > ago(14d) and properties.migration.assessment.enabled == true and isnotnull(parse_json(properties.migration.assessment.skuRecommendationResults))
| extend azureSqlDatabaseRecommendationStatus = tostring(properties.migration.assessment.skuRecommendationResults.azureSqlDatabase.recommendationStatus)
| extend azureSqlManagedInstanceRecommendationStatus = tostring(properties.migration.assessment.skuRecommendationResults.azureSqlManagedInstance.recommendationStatus)
| extend azureSqlVirtualMachineRecommendationStatus = tostring(properties.migration.assessment.skuRecommendationResults.azureSqlVirtualMachine.recommendationStatus)
| extend serverAssessments = tostring(properties.migration.assessment.serverAssessments)
| extend subscriptionId = extract(@"/subscriptions/([^/]+)", 1, id)
| extend resourceGroup = extract(@"/resource[g/G]roups/([^/]+)", 1, id)
| mv-expand platformStatus = pack_array(
pack("platform", "Azure SQL Database", "status", azureSqlDatabaseRecommendationStatus),
pack("platform", "Azure SQL Managed Instance", "status", azureSqlManagedInstanceRecommendationStatus),
pack("platform", "Azure SQL Virtual Machine", "status", azureSqlVirtualMachineRecommendationStatus)
)
| extend platformIncludedString = strcat('"AppliesToMigrationTargetPlatform":', strcat('"', replace(" ", "", tolower(tostring(platformStatus["platform"]))), '"'))
| extend platformHasIssues = tolower(serverAssessments) has tolower(platformIncludedString)
| project Platform = tostring(platformStatus["platform"]), status = tostring(platformStatus["status"]), tostring(serverAssessments), id, platformHasIssues
| extend finalStatus = case(
status == "Ready" and platformHasIssues, "Ready with Conditions",
status == "Ready", "Ready",
status == "NotReady", "NotReady",
isnull(status) or status !in ("Ready", "NotReady", "Ready with Conditions"), "Unknown",
"Unknown")
| summarize TotalAssessed = count(), Ready = countif(finalStatus == "Ready"), NotReady = countif(finalStatus == "NotReady"),
ReadyWithConditions = countif(finalStatus == "Ready with Conditions"), Unknown = countif(finalStatus == "Unknown")
by Platform
az graph query -q "resources | where type =~ 'microsoft.hybridcompute/machines' | extend machineId = tolower(tostring(id)), datacenter = iif(isnull(tags.Datacenter), '', tags.Datacenter), status = tostring(properties.status) | extend mssqlinstalled = coalesce(tobool(properties.detectedProperties.mssqldiscovered),false) | extend pgsqlinstalled = coalesce(tobool(properties.detectedProperties.pgsqldiscovered),false) | extend mysqlinstalled = coalesce(tobool(properties.detectedProperties.mysqldiscovered),false) | extend osSku = properties.osSku, osName = properties.osName, osVersion = properties.osVersion | extend coreCount = tostring(properties.detectedProperties.logicalCoreCount), totalPhysicalMemoryinGB = tostring(properties.detectedProperties.totalPhysicalMemoryInGigabytes) | extend operatingSystem = iif(isnotnull(osSku), osSku, osName) | where mssqlinstalled or mysqlinstalled or pgsqlinstalled | project id ,name, type, resourceGroup, subscriptionId, location, kind, osVersion, status, osSku,coreCount,totalPhysicalMemoryinGB,tags, mssqlinstalled, mysqlinstalled, pgsqlinstalled | sort by (tolower(tostring(name))) asc"