已啟用 Azure Arc 的數據服務資料收集和報告

本文說明已啟用 Azure Arc 的數據服務傳送給 Microsoft 的數據。

已啟用 Azure Arc 的數據服務和任何適用的數據服務都不會儲存任何客戶數據。 這適用於:

  • 由 Azure Arc 啟用 SQL 受管理執行個體
  • 已啟用 Azure Arc 的 PostgreSQL

已啟用 Azure Arc 的資料服務

已啟用 Azure Arc 的數據服務可能會使用下列部分或所有產品:

  • 由 Azure Arc 啟用 SQL 受管理執行個體

  • 已啟用 Azure Arc 的 PostgreSQL

  • Azure Data Studio

    此時,請使用 Azure Data Studio 的測試人員組建。

  • Azure CLI (az)

直接連線

當叢集設定為直接連線到 Azure 時,某些數據會自動傳輸至 Microsoft。

下表描述數據類型、傳送方式和需求。

資料類別 會傳送哪些資料? 如何傳送? 這是必要的嗎?
操作數據 計量與記錄 自動,當設定為這樣做時 No
計費和清查數據 清查,例如實例數目,以及使用量,例如取用的虛擬核心數目 自動 Yes
診斷 用於疑難解答的診斷資訊 手動匯出並提供給 Microsoft 支援服務 僅適用於疑難解答範圍,並遵循標準 隱私策略

間接連線

當叢集未設定為直接連線到 Azure 時,它不會自動將作業或計費和清查數據傳輸到 Microsoft。 若要將數據傳輸到 Microsoft,您必須設定匯出。

下表描述數據類型、傳送方式和需求。

資料類別 會傳送哪些資料? 如何傳送? 這是必要的嗎?
操作數據 計量與記錄 手動 No
計費和清查數據 清查,例如實例數目,以及使用量,例如取用的虛擬核心數目 手動 Yes
診斷 用於疑難解答的診斷資訊 手動匯出並提供給 Microsoft 支援服務 僅適用於疑難解答範圍,並遵循標準 隱私策略

操作數據

所有資料庫實例和已啟用 Azure Arc 的數據服務平臺本身都會收集作業數據。 工作資料有兩種類型:

  • 計量 – 效能和容量相關計量,這些計量會收集到已啟用 Azure Arc 的數據服務一部分提供的 Influx DB。 您可以在提供的 Grafana 儀錶板中檢視這些計量。

  • 記錄 – 所有元件發出的記錄,包括失敗、警告和資訊性事件,都會收集到 Azure Arc 啟用數據服務的一部分提供的 OpenSearch 資料庫。 您可以在提供的 Kibana 儀錶板中檢視記錄。 在 2023 年 5 月版本之前,記錄資料庫使用 Elasticsearch。 之後,它會使用 OpenSearch。

儲存在本機的操作數據需要內建的系統管理許可權,才能在 Grafana/Kibana 中檢視。

除非您選擇匯出/上傳(間接連線模式)或自動將數據傳送至 Azure 監視器/Log Analytics,否則作業數據不會離開您的環境。 數據會進入您控制的Log Analytics工作區。

如果數據傳送至 Azure 監視器或 Log Analytics,您可以選擇 Log Analytics 工作區所在的 Azure 區域或數據中心。 之後,您可以控制從其他位置檢視或複製它。

清查數據

收集的清查數據是由數種 Azure 資源類型表示。 下列各節顯示針對每個資源類型收集的屬性、類型和描述:

每個資料庫實例和數據控制器本身都會反映在 Azure 中作為 Azure Resource Manager 中的 Azure 資源。

資源類型有三種:

  • 由 Azure Arc 啟用 SQL 受管理執行個體
  • 已啟用 Azure Arc 的 PostgreSQL 伺服器
  • 數據控制者

下列各節顯示收集並儲存每個資源類型的屬性、類型和描述:

SQL Server - Azure Arc

Description 屬性名稱 屬性類型
電腦名稱 NAME 字串
SQL Server 執行個體名稱 INSTANCENAME 字串
SQL Server 版本 version string
SQL Server 版本 edition 字串
包含伺服器資源識別碼 containerResourceId 字串
虛擬核心 虛擬核心 字串
連線ivity狀態 status 字串
SQL Server 修補程式層級 patchLevel 字串
定序 整理 字串
目前版本 currentVersion 字串
TCP 動態埠 tcpDynamicPorts 字串
TCP 靜態埠 tcpStaticPorts 字串
產品識別碼 productId 字串
授權類型 licenseType string
Microsoft Defender 狀態 azureDefenderStatus string
Microsoft Defender 狀態上次更新 azureDefenderStatusLastUpdated string
佈建狀態 provisioningState 字串

下列 JSON 文件是 SQL Server - Azure Arc 資源的範例。

{
  
    "name": "SQL22-EE_PAYGTEST",
    "version": "SQL Server 2022",
    "edition": "Enterprise",
    "containerResourceId": "/subscriptions/a5082b19-8a6e-4bc5-8fdd-8ef39dfebc39/resourcegroups/sashan-arc-eastasia/providers/Microsoft.HybridCompute/machines/SQL22-EE",
    "vCore": "8",
    "status": "Connected",
    "patchLevel": "16.0.1000.6",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "currentVersion": "16.0.1000.6",
    "instanceName": "PAYGTEST",
    "tcpDynamicPorts": "61394",
    "tcpStaticPorts": "",
    "productId": "00488-00010-05000-AB944",
    "licenseType": "PAYG",
    "azureDefenderStatusLastUpdated": "2023-02-08T07:57:37.5597421Z",
    "azureDefenderStatus": "Protected",
    "provisioningState": "Succeeded"
}

SQL Server 資料庫 - Azure Arc

Description 屬性名稱 屬性類型
資料庫名稱 NAME 字串
定序 collationName 字串
Database creation date databaseCreationDate System.DateTime
相容性層級 compatibilityLevel 字串
資料庫狀態 State 字串
唯讀模式 isReadOnly boolean
復原模式 recoveryMode boolean
自動關閉已啟用 isAutoCloseOn boolean
自動壓縮已啟用 isAutoShrinkOn boolean
自動建立統計資料已啟用 isAutoCreateStatsOn boolean
自動更新統計資料已啟用 isAutoUpdateStatsOn boolean
遠端資料封存已啟用 isRemoteDataArchiveEnabled boolean
! 記憶體最佳化已啟用 isMemoryOptimizationEnabled boolean
加密已啟用 isEncrypted boolean
可信任模式已啟用 isTrustworthyOn boolean
備份資訊 backupInformation
佈建狀態 provisioningState 字串

下列 JSON 文件是 SQL Server 資料庫 - Azure Arc 資源的範例。

{
    "name": "newDb80",
    "collationName": "SQL_Latin1_General_CP1_CI_AS",
    "databaseCreationDate": "2023-01-09T03:40:45Z",
    "compatibilityLevel": 150,
    "state": "Online",
    "isReadOnly": false,
    "recoveryMode": "Full",
    "databaseOptions": {
        "isAutoCloseOn": false,
        "isAutoShrinkOn": false,
        "isAutoCreateStatsOn": true,
        "isAutoUpdateStatsOn": true,
        "isRemoteDataArchiveEnabled": false,
        "isMemoryOptimizationEnabled": true,
        "isEncrypted": false,
        "isTrustworthyOn": false
    },
    "backupInformation": {},
    "provisioningState": "Succeeded"
}

Azure Arc 資料控制器

Description 屬性名稱 屬性類型
位置資訊 OnPremiseProperty public:OnPremiseProperty
原始 Kubernetes 資訊 (kubectl get datacontroller K8sRaw object
上次從內部部署叢集上傳的日期 LastUploadedDate System.DateTime
數據控制器狀態 ProvisioningState 字串

下列 JSON 檔是 Azure Arc 數據控制器資源的範例。

{
    "id": "/subscriptions/7894901a-dfga-rf4d-85r4-cc1234459df2/resourceGroups/contoso-rg/providers/Microsoft.AzureArcData/dataControllers/contosodc",
    "name": "contosodc",
    "type": "microsoft.azurearcdata/datacontrollers",
    "location": "eastus",
    "extendedLocation": {
        "name": "/subscriptions/7894901a-dfga-rf4d-85r4-cc1234459df2/resourceGroups/contoso-rg/providers/Microsoft.ExtendedLocation/customLocations/contoso",
        "type": "CustomLocation"
    },
    "tags": {},
    "systemData": {
        "createdBy": "contosouser@contoso.com",
        "createdByType": "User",
        "createdAt": "2023-01-03T21:35:36.8412132Z",
        "lastModifiedBy": "319f651f-7ddb-4fc6-9857-7aef9250bd05",
        "lastModifiedByType": "Application",
        "lastModifiedAt": "2023-02-15T17:13:26.6429039Z"
    },
    "properties": {
        "infrastructure": "azure",
        "onPremiseProperty": {
            "id": "4eb0a7a5-5ed6-4463-af71-12590b2fad5d",
            "publicSigningKey": "MIIDWzCCAkOgAwIBAgIIA8OmTJKpD8AwDQYJKoZIhvcNAQELBQAwKDEmMCQGA1UEAxMdQ2x1c3RlciBDZXJ0aWZpY2F0ZSBBdXRob3JpdHkwHhcNMjMwMTAzMjEzNzUxWhcNMjgwMTAyMjEzNzUxWjAaMRgwFgYDVQQDEw9iaWxsaW5nLXNpZ25pbmcwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQC3rAuXaXIeaipFiqGW5rtkdq/1+S58CRMEkANHvwFnimXEWIt8VnbG9foIm20r0RK+6XeRpn5r92jrOl/3R4Q9AAiF3Tgzy3NF9Dg9OsKo1bnrfWHMxmyX2w8TxyZSvWKEUVpVhjhqyhy/cqSJA5ASjEtthMx4Q1HTVcEDSTfnPHPz9EhfZqZ6ES3Yqun2D9MIatkSUpjHJbqYwRTzzrsPG84hJX7EGAWntvEzzCjmTUsouShEwUhi8c05CLBwzF5bxDNLhTdy+tj2ZyUzL7R+BmifwPR9jvOziYPlrbgIIs77sPbNlZjZvMeeBaJHktWZ0s8/UpUpV1W69m7hT2gbAgMBAAGjgZYwgZMwIAYDVR0lAQH/BBYwFAYIKwYBBQUHAwIGCCsGAQUFBwMBMA4GA1UdDwEB/wQEAwIFoDBfBgNVHREEWDBWgg5jb250cm9sbGVyLXN2Y4IoY29udHJvbGxlci1zdmMuY29udG9zby5zdmMuY2x1c3Rlci5sb2NhbIIaY29udHJvbGxlci1zdmMuY29udG9zby5zdmMwDQYJKoZIhvcNAQELBQADggEBADcZNIZcDDUC79ElbRrXdbHo9bUUv/NJfY7Dx226jc8j0AdDq8MbHAnt+JiMH6+GDb88avleA448yZ9ujBP9zC8v8IyaWu4vQpPT7MagzlsAhb6VEWU0FQfM6R14WwbATWSOIwDlMn4I33mZULyJdZhk4TqzqTQ8F0I3TavHh8TWBbjnwg1IhR/8TQ9HfgceoI80SBE3BDI5at/CzYgoWcWS2pzfd3QYwD8DIPVLCdcx1LNSDjdlQCQTKal0yKMauGIzMuYpCF1M6Z0LunPU/Ns96T9mqLXJHu+wmAoJ2CwdXa4FruwTSgrQlY3pokjTMwGaP3uzpnCSI7ykvi5kp4Q=",
            "signingCertificateThumbprint": "8FB48D0DD44DCFB25ECC13B9CB5F493F5438D38C"
        },
        "k8sRaw": {
            "kind": "DataController",
            "spec": {
                "credentials": {
                    "dockerRegistry": "arc-private-registry",
                    "domainServiceAccount": "domain-service-account-secret",
                    "serviceAccount": "sa-arc-controller"
                },
                "security": {
                    "allowDumps": true,
                    "allowNodeMetricsCollection": true,
                    "allowPodMetricsCollection": true
                },
                "services": [
                    {
                        "name": "controller",
                        "port": 30080,
                        "serviceType": "LoadBalancer"
                    }
                ],
                "settings": {
                    "ElasticSearch": {
                        "vm.max_map_count": "-1"
                    },
                    "azure": {
                        "autoUploadMetrics": "true",
                        "autoUploadLogs": "false",
                        "subscription": "7894901a-dfga-rf4d-85r4-cc1234459df2",
                        "resourceGroup": "contoso-rg",
                        "location": "eastus",
                        "connectionMode": "direct"
                    },
                    "controller": {
                        "logs.rotation.days": "7",
                        "logs.rotation.size": "5000",
                        "displayName": "contosodc"
                    }
                },
                "storage": {
                    "data": {
                        "accessMode": "ReadWriteOnce",
                        "className": "managed-premium",
                        "size": "15Gi"
                    },
                    "logs": {
                        "accessMode": "ReadWriteOnce",
                        "className": "managed-premium",
                        "size": "10Gi"
                    }
                },
                "infrastructure": "azure",
                "docker": {
                    "registry": "mcr.microsoft.com",
                    "imageTag": "v1.14.0_2022-12-13",
                    "repository": "arcdata",
                    "imagePullPolicy": "Always"
                }
            },
            "metadata": {
                "namespace": "contoso",
                "name": "contosodc",
                "annotations": {
                    "management.azure.com/apiVersion": "2022-03-01-preview",
                    "management.azure.com/cloudEnvironment": "AzureCloud",
                    "management.azure.com/correlationId": "aa531c88-6dfb-46c3-af5b-d93f7eaaf0f6",
                    "management.azure.com/customLocation": "/subscriptions/7894901a-dfga-rf4d-85r4-cc1234459df2/resourceGroups/contoso-rg/providers/Microsoft.ExtendedLocation/customLocations/contoso",
                    "management.azure.com/location": "eastus",
                    "management.azure.com/operationId": "265b98a7-0fc2-4dce-9cef-26f9b6dd000c*705EDFCA81D01028EFA1C3E9CB3CEC2BF472F25894ACB2FFDF955711236F486D",
                    "management.azure.com/resourceId": "/subscriptions/7894901a-dfga-rf4d-85r4-cc1234459df2/resourceGroups/contoso-rg/providers/Microsoft.AzureArcData/dataControllers/contosodc",
                    "management.azure.com/systemData": "{\"createdBy\":\"9c1a17be-338f-4b3c-90e9-55eb526c5aef\",\"createdByType\":\"User\",\"createdAt\":\"2023-01-03T21:35:36.8412132Z\",\"resourceUID\":\"74087467-4f98-4a23-bacf-a1e40404457f\"}",
                    "management.azure.com/tenantId": "123488bf-8asd-41wf-91ab-211kl345db47",
                    "traceparent": "00-197d885376f938d6138babf8ed4d809c-1a584b84b3c8f5df-01"
                },
                "creationTimestamp": "2023-01-03T21:35:42Z",
                "generation": 2,
                "resourceVersion": "15446366",
                "uid": "4eb0a7a5-5ed6-4463-af71-12590b2fad5d"
            },
            "apiVersion": "arcdata.microsoft.com/v5",
            "status": {
                "observedGeneration": 2,
                "state": "Ready",
                "azure": {
                    "uploadStatus": {
                        "logs": {
                            "lastUploadTime": "0001-01-01T00:00:00Z",
                            "message": "Automatic upload of logs is disabled. Execution time: 02/15/2023 17:07:57"
                        },
                        "metrics": {
                            "lastUploadTime": "2023-02-15T17:00:57.047934Z",
                            "message": "Success"
                        },
                        "usage": {
                            "lastUploadTime": "2023-02-15T17:07:53.843439Z",
                            "message": "Success. Records uploaded: 1."
                        }
                    }
                },
                "lastUpdateTime": "2023-02-15T17:07:57.587925Z",
                "runningVersion": "v1.14.0_2022-12-13",
                "arcDataServicesK8sExtensionLatestVersion": "v1.16.0",
                "registryVersions": {
                    "available": [
                        "v1.16.0_2023-02-14",
                        "v1.15.0_2023-01-10"
                    ],
                    "behind": 2,
                    "current": "v1.14.0_2022-12-13",
                    "latest": "v1.16.0_2023-02-14",
                    "next": "v1.15.0_2023-01-10",
                    "previous": "v1.13.0_2022-11-08"
                }
            }
        },
        "provisioningState": "Succeeded"
    }
}

PostgreSQL 伺服器 - Azure Arc

Description 屬性名稱 屬性類型
數據控制器標識碼 DataControllerId string
實例管理員名稱 管理 string
基本身份驗證的使用者名稱和密碼 BasicLoginInformation public:BasicLoginInformation
原始 Kubernetes 資訊 (kubectl get postgres12 K8sRaw object
上次從內部部署叢集上傳的日期 LastUploadedDate System.DateTime
群組布建狀態 ProvisioningState 字串

SQL 受控實例 - Azure Arc

Description 屬性名稱 屬性類型
受控實例標識碼 DataControllerId string
實例管理員用戶名稱 管理 string
實例開始時間 StartTime string
實例結束時間 EndTime string
原始 Kubernetes 資訊 (kubectl get sqlmi K8sRaw object
基本身份驗證的使用者名稱和密碼 BasicLoginInformation BasicLoginInformation
上次從內部部署叢集上傳的日期 LastUploadedDate System.DateTime
SQL 受控實例布建狀態 ProvisioningState 字串

下列 JSON 檔是 SQL 受管理執行個體 - Azure Arc 資源的範例。


{
    "id": "/subscriptions/7894901a-dfga-rf4d-85r4-cc1234459df2/resourceGroups/contoso-rg/providers/Microsoft.AzureArcData/sqlManagedInstances/sqlmi1",
    "name": "sqlmi1",
    "type": "microsoft.azurearcdata/sqlmanagedinstances",
    "sku": {
        "name": "vCore",
        "tier": "BusinessCritical"
    },
    "location": "eastus",
    "extendedLocation": {
        "name": "/subscriptions/7894901a-dfga-rf4d-85r4-cc1234459df2/resourcegroups/contoso-rg/providers/microsoft.extendedlocation/customlocations/contoso",
        "type": "CustomLocation"
    },
    "tags": {},
    "systemData": {
        "createdBy": "contosouser@contoso.com",
        "createdByType": "User",
        "createdAt": "2023-01-04T01:33:57.5232885Z",
        "lastModifiedBy": "319f651f-7ddb-4fc6-9857-7aef9250bd05",
        "lastModifiedByType": "Application",
        "lastModifiedAt": "2023-02-15T01:39:11.6582399Z"
    },
    "properties": {
        "dataControllerId": "/subscriptions/7894901a-dfga-rf4d-85r4-cc1234459df2/resourceGroups/contoso-rg/providers/Microsoft.AzureArcData/dataControllers/contosodc",
        "admin": "sqladmin",
        "k8sRaw": {
            "spec": {
                "scheduling": {
                    "default": {
                        "resources": {
                            "requests": {
                                "cpu": "2",
                                "memory": "4Gi"
                            },
                            "limits": {
                                "cpu": "2",
                                "memory": "4Gi"
                            }
                        }
                    }
                },
                "replicas": 2,
                "dev": true,
                "services": {
                    "primary": {
                        "type": "LoadBalancer"
                    },
                    "readableSecondaries": {}
                },
                "readableSecondaries": 1,
                "syncSecondaryToCommit": 0,
                "storage": {
                    "data": {
                        "volumes": [
                            {
                                "size": "5Gi"
                            }
                        ]
                    },
                    "logs": {
                        "volumes": [
                            {
                                "size": "5Gi"
                            }
                        ]
                    },
                    "datalogs": {
                        "volumes": [
                            {
                                "size": "5Gi"
                            }
                        ]
                    },
                    "backups": {
                        "volumes": [
                            {
                                "className": "azurefile",
                                "size": "5Gi"
                            }
                        ]
                    }
                },
                "security": {
                    "adminLoginSecret": "sqlmi1-login-secret"
                },
                "tier": "BusinessCritical",
                "update": {},
                "backup": {
                    "retentionPeriodInDays": 7
                },
                "licenseType": "LicenseIncluded",
                "orchestratorReplicas": 1,
                "parentResource": {
                    "apiGroup": "arcdata.microsoft.com",
                    "kind": "DataController",
                    "name": "contosodc",
                    "namespace": "contoso"
                },
                "settings": {
                    "collation": "SQL_Latin1_General_CP1_CI_AS",
                    "language": {
                        "lcid": 1033
                    },
                    "network": {
                        "forceencryption": 0,
                        "tlsciphers": "ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-SHA384",
                        "tlsprotocols": "1.2"
                    },
                    "sqlagent": {
                        "enabled": false
                    },
                    "timezone": "UTC"
                }
            },
            "metadata": {
                "annotations": {
                    "management.azure.com/apiVersion": "2022-03-01-preview",
                    "management.azure.com/cloudEnvironment": "AzureCloud",
                    "management.azure.com/correlationId": "3a49178d-a09f-48d3-9292-3133f6591743",
                    "management.azure.com/customLocation": "/subscriptions/7894901a-dfga-rf4d-85r4-cc1234459df2/resourceGroups/contoso-rg/providers/microsoft.extendedlocation/customlocations/contoso",
                    "management.azure.com/location": "eastus",
                    "management.azure.com/operationId": "dbf2e708-78da-4762-8fd5-75ba43721b24*4C234309E6735F28E751F5734D64E8F98A910A88E54A1AD35C6469BCD0E6EA84",
                    "management.azure.com/resourceId": "/subscriptions/7894901a-dfga-rf4d-85r4-cc1234459df2/resourceGroups/contoso-rg/providers/Microsoft.AzureArcData/sqlManagedInstances/sqlmi1",
                    "management.azure.com/systemData": "{\"createdBy\":\"9c1a17be-338f-4b3c-90e9-55eb526c5aef\",\"createdByType\":\"User\",\"createdAt\":\"2023-01-04T01:33:57.5232885Z\",\"resourceUID\":\"40fa8b55-4b7d-4d6a-b783-043169d7fd03\"}",
                    "management.azure.com/tenantId": "123488bf-8asd-41wf-91ab-211kl345db47",
                    "traceparent": "00-3c07cf4caa8b4778591b02b1bf3979ef-f2ee2c890c21ea8a-01"
                },
                "creationTimestamp": "2023-01-04T01:34:03Z",
                "generation": 1,
                "labels": {
                    "management.azure.com/resourceProvider": "Microsoft.AzureArcData"
                },
                "name": "sqlmi1",
                "namespace": "contoso",
                "resourceVersion": "15215035",
                "uid": "6d653cd8-f17e-437a-b0dc-48154164c1ad"
            },
            "status": {
                "lastUpdateTime": "2023-02-15T01:39:07.691211Z",
                "observedGeneration": 1,
                "readyReplicas": "2/2",
                "roles": {
                    "sql": {
                        "replicas": 2,
                        "lastUpdateTime": "2023-02-14T11:37:14.875705Z",
                        "readyReplicas": 2
                    }
                },
                "state": "Ready",
                "endpoints": {
                    "logSearchDashboard": "https://230.41.13.18:5601/app/kibana#/discover?_a=(query:(language:kuery,query:'custom_resource_name:sqlmi1'))",
                    "metricsDashboard": "https://230.41.13.18:3000/d/40q72HnGk/sql-managed-instance-metrics?var-hostname=sqlmi1-0",
                    "mirroring": "230.41.13.18:5022",
                    "primary": "230.41.13.18,1433",
                    "secondary": "230.41.13.18,1433"
                },
                "highAvailability": {
                    "lastUpdateTime": "2023-02-14T11:47:42.208708Z",
                    "mirroringCertificate": "-----BEGIN CERTIFICATE-----\nMIIDQzCCAiugAwIBAgIISqqmfCPaolkwDQYJKoZIhvcNAQELBQAwKDEmMCQGA1UEAxMdQ2x1c3Rl\r\nciBDZXJ0aWZpDEzNDA2WhcNMjgwMTAzMDEzNDA2WjAO\r\nMQwwCgYDVQQDEwNkYm0wggEiMA0GCSqgEKAoIBAQDEXj2nm2cGkyfu\r\npXWQ4s6G//AI1rbH4JStZOAHwJNYmBuESSHz0i6znjnQQloFe+g2KM+1m4TN1T39Lz+/ufEYQQX9\r\nx9WuGP2IALgH1LXc/0DGuOB16QXqN7ZWULQ4ovW4Aaz5NxTSDXWYPK+zpb1c8adsQyamLHwmSPs4\r\nMpsgfOR9EUCqdnuKjSHbWCtkJTYogpAFyZb5HOgY1TMICrTkXG6VYoCPS/EDNmtPOyVuykdjjsxx\r\nIC5KkVgHWTaYIDjim7L44FPh4HUIVM/OFScRijCZTJogN/Fe94+kGDWfgWIG36Jlz127BbWV3HNJ\r\nkH2oLchIABvgTXsdKnjK3i2TAgMBAAGjgYowgYcwIAYDVR0lAQH/BBYwFAYIKwYBBQUHAwIGCCsG\r\nAQUFBwMBMA4GA1UdDwEB/wQEAwIFoDBTBgNVHREETDBKggpzcWxtaTEtc3ZjgiRzcWxtaTEtc3Zj\r\nLmNvbnRvc28uc3ZjLmNsdXN0ZXIubG9jYWyCFnNxbG1pMS1zdmMuY29udG9zby5zdmMwDQYJKoZI\r\nhvcNAQELBQADggEBAA+Wj6WK9NgX4szxT7zQxPVIn+0iviO/2dFxHmjmvj+lrAffsgNdfeX5095f\r\natxIO+no6VW2eoHze2f6AECh4/KefyAzd+GL9MIksJcMLqSqAemXju3pUfGBS1SAW8Rh361D8tmA\r\nEFpPMwZG3uMidYMso0GqO0tpejz2+5Q4NpweHBGoq6jk+9ApTLD+s5qetZHrxGD6tS1Z/Lvt24lE\r\nKtSKEDw5O2qnqbsOe6xxtPAuIfTmpwIzIv2WiGC3aGuXSr0bNyPHzh5RL1MCIpwLMrnruFwVzB25\r\nA0xRalcXVZRZ1H0zbznGsecyBRJiA+7uxNB7/V6i+SjB/qxj2xKh4s8=\n-----END CERTIFICATE-----\n",
                    "healthState": "Error",
                    "replicas": []
                },
                "logSearchDashboard": "https://230.41.13.18:5601/app/kibana#/discover?_a=(query:(language:kuery,query:'custom_resource_name:sqlmi1'))",
                "metricsDashboard": "https://230.41.13.18:3000/d/40q72HnGk/sql-managed-instance-metrics?var-hostname=sqlmi1-0",
                "primaryEndpoint": "230.41.13.18,1433",
                "runningVersion": "v1.14.0_2022-12-13",
                "registryVersions": {
                    "available": [],
                    "behind": 0,
                    "current": "v1.14.0_2022-12-13",
                    "latest": "v1.14.0_2022-12-13",
                    "previous": "v1.13.0_2022-11-08"
                }
            }
        },
        "provisioningState": "Succeeded",
        "licenseType": "LicenseIncluded"
    }
}

範例

傳送至 Azure 以在訂用帳戶中建立 Azure 資源的資源清查數據 JSON 檔範例。

{ 

        "customObjectName": "<resource type>-2020-29-5-23-13-17-164711", 
        "uid": "4bc3dc6b-9148-4c7a-b7dc-01afc1ef5373", 
        "instanceName": "sqlInstance001", 
        "instanceNamespace": "arc", 
        "instanceType": "<resource>", 
        "location": "eastus", 
        "resourceGroupName": "production-resources", 
        "subscriptionId": "<subscription_id>", 
        "isDeleted": false, 
        "externalEndpoint": "32.191.39.83:1433", 
        "vCores": "2", 
        "createTimestamp": "05/29/2020 23:13:17", 
        "updateTimestamp": "05/29/2020 23:13:17" 
    } 

帳單數據

計費數據用於追蹤可計費的使用量。 此數據對於執行服務至關重要,而且必須在所有模式中手動或自動傳輸。

已啟用 Arc 的數據服務

計費數據會擷取指定實例的開始時間(“created”)和結束時間(“deleted”),以及每當給定實例可用的核心數目變更時,就會發生任何開始和時間。

{ 
    "requestType": "usageUpload", 
    "clusterId": "4b0917dd-e003-480e-ae74-1a8bb5e36b5d", 
    "name": "DataControllerTestName", 
    "subscriptionId": "<subscription_id>", 
    "resourceGroup": "production-resources", 
    "location": "eastus", 
    "uploadRequest": { 
    "exportType": "usages", 
    "dataTimestamp": "2020-06-17T22:32:24Z", 
    "data": 
        "[{\"name\":\"sqlInstance001\", 
        \"namespace\":\"arc\", 
        \"type\":\"<resource type>\", 
        \"eventSequence\":1,  
        \"eventId\":\"50DF90E8-FC2C-4BBF-B245-CB20DC97FF24\", 
        \"startTime\":\"2020-06-17T19:11:47.7533333\", 
        \"endTime\":\"2020-06-17T19:59:00\", 
        \"quantity\":1, 
        \"id\":\"<subscription_id>\"}]", 
        "signature":"MIIE7gYJKoZIhvcNAQ...2xXqkK" 

已啟用 Arc 的 SQL Server

計費數據會擷取 SQL Server 實例屬性的快照集,以及每小時的電腦屬性,並撰寫使用量上傳承載以報告使用量。 每個 SQL Server 實例的承載中有快照集時間。 

{
    "hostType": "Unknown",
    "osType": "Windows",
    "manufacturer": "Microsoft",
    "model": "Hyper-V",
    "isVirtualMachine": true,
    "serverName": "TestArcServer",
    "serverId": "<server id>",
    "location": "eastus",
    "timestamp": "2021-07-08T01:42:15.0388467Z",
    "uploadRequest": {
        "exportType": "usages",
        "dataTimestamp": "2020-06-17T22:32:24Z",
        "data": 
            "[{\"hostType\":\"VirtualMachine\",
            \"numberOfCores\":4,
            \"numberOfProcessors\":1,
            \"numberOfLogicalProcessors\":4,
            \"subscriptionId\":\"<subscription id>\",\"resourceGroup\":\"ArceeBillingPipelineStorage_Test\",
            \"location\":\"eastus2euap\",
            \"version\":\"Sql2019\",
            \"edition\":\"Enterprise\",
            \"editionOriginalString\":\"Enterprise Edition: Core based licensing\",
            \"coreInfoOriginalString\":\"using 16 logical processors based on SQL Server licensing\",
            \"vCore\":4,
            \"instanceName\":\"INSTANCE01\",
            \"licenseType\":\"LicenseOnly\",
            \"hostLicenseType\":\"Paid\",
            \"instanceLicenseType\":\"Paid\",
            \"serverName\":\"TestArcServer\",
            \"isRunning\":false,
            \"eventId\":\"00000000-0000-0000-0000-000000000000\",
            \"snapshotTime\":\"2020-06-17T19:59:00\",
            \"isAzureBilled\":\"Enabled\",
            \"hasSoftwareAssurance\":\"Undefined\"}]"
    }
}

診斷資料

在支持情況下,系統可能會要求您提供資料庫實例記錄、Kubernetes 記錄和其他診斷記錄。 支援小組會提供安全的位置,讓您上傳至該位置。 動態管理檢視 (DMV) 也可能提供診斷數據。 使用的 DMV 或查詢可能包含資料庫架構元數據詳細數據,但通常不是客戶數據。 診斷數據不包含任何密碼、叢集IP或個別可識別的數據。 系統會清除這些記錄,而且記錄會盡可能針對記憶體進行匿名處理。 它們不會自動傳輸,系統管理員必須手動上傳它們。

欄位名稱 備註
錯誤記錄 擷取錯誤的記錄檔可能包含客戶或個人資料(請參閱下方)受到使用者限制和共用
DMV 動態管理檢視可以包含查詢和查詢計劃,但受到使用者的限制和共用
檢視 檢視可以包含客戶數據,但只能由使用者限制和共用
損毀傾印 – 客戶數據 損毀傾印最多保留 30 天 – 可能包含存取控制數據

統計數據對象、數據列內的數據值、查詢文字可能位於客戶損毀傾印中
損毀傾印 – 個人資料 計算機、登入/使用者名稱、電子郵件、位置資訊、客戶識別 – 需要包含使用者同意

將使用量數據上傳至 Azure 監視器