使用 Azure SQL 分析來監視 Azure SQL Database (預覽)Monitor Azure SQL Database using Azure SQL Analytics (Preview)

Azure SQL 分析符號

Azure SQL 分析是一個進階雲端監視解決方案,可以透過單一窗格跨多個訂用帳戶大規模監視 Azure SQL 資料庫、彈性集區和受控執行個體的效能。Azure SQL Analytics is an advanced cloud monitoring solution for monitoring performance of Azure SQL databases, elastic pools, and Managed Instances at scale and across multiple subscriptions through a single pane of glass. 它會收集重要的 Azure SQL Database 效能計量,並且以視覺效果方式呈現,具有內建智慧可以執行效能疑難排解。It collects and visualizes important Azure SQL Database performance metrics with built-in intelligence for performance troubleshooting.

藉由使用您以解決方案收集的計量,您可以建立自訂的監視規則和警示。By using metrics that you collect with the solution, you can create custom monitoring rules and alerts. 解決方案可協助您找出應用程式堆疊中每個層級的問題。The solution helps you to identify issues at each layer of your application stack. 它會使用 Azure 診斷計量,以及 Azure 監視器檢視您所有 Azure SQL 資料庫、 彈性集區和資料庫的相關資料呈現單一 Log Analytics 工作區中的 受控執行個體。It uses Azure Diagnostic metrics along with Azure Monitor views to present data about all your Azure SQL databases, elastic pools, and databases in Managed Instances in a single Log Analytics workspace. Azure 監視器可協助您收集、 相互關聯,並以視覺化方式檢視結構化和非結構化資料。Azure Monitor helps you to collect, correlate, and visualize structured and unstructured data.

如需使用 Azure SQL Analytics 解決方案,以及一般使用案例的實際操作概觀,請觀看內嵌影片:For a hands-on overview on using Azure SQL Analytics solution and for typical usage scenarios, see the embedded video:

連接的來源Connected sources

Azure SQL 分析是僅限雲端的監視解決方案,支援適用於 Azure SQL 資料庫 (單一、集區,以及受控執行個體資料庫) 的診斷遙測串流。Azure SQL Analytics is a cloud only monitoring solution supporting streaming of diagnostics telemetry for Azure SQL databases: single, pooled, and Managed Instance databases. 解決方案不使用連接至 Azure 監視代理程式,因為方案不支援監視裝載的 SQL Server 內部部署或在 Vm 中,請參閱以下的相容性表格。As the solution does not use agents to connect to Azure Monitor, the solution does not support monitoring of SQL Server hosted on-premises or in VMs, see the compatibility table below.

連接的來源Connected Source 支援Supported 描述Description
Azure 診斷Azure Diagnostics Yes Azure 計量與記錄資料會直接傳送至 Azure 監視器記錄檔 Azure。Azure metric and log data are sent to Azure Monitor Logs directly by Azure.
Azure 儲存體帳戶Azure storage account No Azure 監視器不會從儲存體帳戶讀取資料。Azure Monitor doesn't read the data from a storage account.
Windows 代理程式Windows agents No 解決方案不使用直接 Windows 代理程式。Direct Windows agents aren't used by the solution.
Linux 代理程式Linux agents No 解決方案不使用直接 Linux 代理程式。Direct Linux agents aren't used by the solution.
System Center Operations Manager 管理群組System Center Operations Manager management group No 從 Operations Manager 代理程式的直接連線至 Azure 監視器不會使用此解決方案。A direct connection from the Operations Manager agent to Azure Monitor is not used by the solution.

組態Configuration

使用中的程序從方案庫新增 Azure 監視解決方案將 Azure SQL 分析 (預覽) 解決方案新增至您的 Log Analytics 工作區。Use the process described in Add Azure Monitor solutions from the Solutions Gallery to add the Azure SQL Analytics (Preview) solution to your Log Analytics workspace.

設定 Azure SQL Database、彈性集區 和受控執行個體以串流診斷遙測Configure Azure SQL Databases, elastic pools and Managed Instances to stream diagnostics telemetry

在您於工作區中建立 Azure SQL Analytics 解決方案之後,您必須設定每個您想要監視的資源,以將它的診斷遙測串流至解決方案。Once you have created Azure SQL Analytics solution in your workspace, you need to configure each resources that you want to monitor to stream its diagnostics telemetry to the solution. 遵循此頁面上的詳細指示:Follow detailed instructions on this page:

上述頁面同時提供啟用支援將單一 Azure SQL 分析工作區作為單一窗口來監視多個 Azure 訂用帳戶的操作指示。The above page also provides instructions on enabling support for monitoring multiple Azure subscriptions from a single Azure SQL Analytics workspace as a single pane of glass.

使用解決方案Using the solution

當您將解決方案新增至您的工作區時,Azure SQL 分析圖格會新增至您的工作區,而且會顯示在 [概觀] 中。When you add the solution to your workspace, the Azure SQL Analytics tile is added to your workspace, and it appears in Overview. 選取 檢視摘要連結,以載入磚內容。Select View Summary link to load the tile content.

Azure SQL 分析摘要圖格

載入之後,圖格會顯示 Azure SQL 資料庫、 彈性集區、 受控執行個體和資料庫的數字,方案會接收從診斷遙測的受控執行個體中。Once loaded, the tile shows the number of Azure SQL databases, elastic pools, Managed Instances, and databases in Managed instances that the solution is receiving diagnostics telemetry from.

Azure SQL 分析圖格

解決方案可提供兩個不同的檢視,一個用於監視 Azure SQL Database 和彈性集區,另一個檢視用於監視受控執行個體和受控執行個體中的資料庫。The solution provides two separate views -- one for monitoring Azure SQL Databases and elastic pools, and the other view for monitoring Managed Instance, and databases in Managed Instances.

若要檢視適用於 Azure SQL Database 和彈性集區的 Azure SQL 分析監視儀表板,請按一下圖格的上半部。To view Azure SQL Analytics monitoring dashboard for Azure SQL Databases and elastic pools, click on the upper part of the tile. 若要檢視適用於受控執行個體和受控執行個體資料庫的 Azure SQL 分析監視儀表板,請按一下圖格的下半部。To view Azure SQL Analytics monitoring dashboard for Managed Instance, and databases in Managed Instance, click on the lower part of the tile.

檢視 Azure SQL 分析資料Viewing Azure SQL Analytics data

儀表板包含透過不同檢視方塊監視之所有資料庫的概觀。The dashboard includes the overview of all databases that are monitored through different perspectives. 若要使用不同的檢視方塊,您必須啟用適當的計量或記錄檔串流處理至 Log Analytics 工作區的 SQL 資源上。For different perspectives to work, you must enable proper metrics or logs on your SQL resources to be streamed to Log Analytics workspace.

請注意,是否某些計量或記錄檔不會串流至 Azure 監視器中,方案中的圖格會不會填入監視資訊。Note that if some metrics or logs are not streamed into Azure Monitor, the tiles in the solution are not populated with monitoring information.

Azure SQL Database 和彈性集區檢視Azure SQL Database and elastic pool view

選取適用於資料庫的 [Azure SQL 分析] 圖格後,便會顯示監視儀表板。Once the Azure SQL Analytics tile for the database is selected, the monitoring dashboard is shown.

Azure SQL 分析概觀

選取任何磚,以便在特定的檢視方塊中開啟向下鑽研報表。Selecting any of the tiles, opens a drill-down report into the specific perspective. 一旦選取檢視方塊,向下鑽研報表隨即開啟。Once the perspective is selected, the drill-down report is opened.

Azure SQL 分析逾時

此檢視中的每個檢視方塊都會提供訂用帳戶、伺服器、彈性集區和資料庫層級的摘要。Each perspective in this view provides summaries on subscription, server, elastic pool, and database level. 此外,每個檢視方塊都會在右側顯示檢視方塊專屬的報表。In addition, each perspective shows a perspective specific to the report on the right. 從清單中選取訂用帳戶、伺服器、集區或資料庫可繼續往下鑽研。Selecting subscription, server, pool, or database from the list continues the drill-down.

受控執行個體和受控執行個體中的資料庫檢視Managed Instance and databases in Managed Instance view

選取適用於資料庫的 [Azure SQL 分析] 圖格後,便會顯示監視儀表板。Once the Azure SQL Analytics tile for the databases is selected, the monitoring dashboard is shown.

Azure SQL 分析概觀

選取任何磚,以便在特定的檢視方塊中開啟向下鑽研報表。Selecting any of the tiles, opens a drill-down report into the specific perspective. 一旦選取檢視方塊,向下鑽研報表隨即開啟。Once the perspective is selected, the drill-down report is opened.

選取 [受控執行個體] 檢視會顯示受控執行個體使用量的詳細資料、其所包含的資料庫,以及跨執行個體所執行的查詢遙測。Selecting Managed Instance view, shows details on the Managed Instance utilization, databases it contains, and telemetry on the queries executed across the instance.

Azure SQL 分析逾時

檢視方塊Perspectives

下表概述兩個儀表板版本所支援的檢視方塊,一個適用於 Azure SQL 資料庫和彈性集區,另一個適用於受控執行個體。The below table outlines perspectives supported for two versions of the dashboard, one for Azure SQL database and elastic pools, and the other one for Managed Instance.

檢視方塊Perspective 描述Description SQL Database 和彈性集區支援SQL Database and elastic pools support 支援受控執行個體Managed Instance support
資源 (依類型)Resource by type 可計算所有受監視資源的檢視方塊。Perspective that counts all the resources monitored. Yes Yes
深入解析Insights 可透過階層的方式,向下鑽研至 Intelligent Insights 乃至效能。Provides hierarchical drill-down into Intelligent Insights into performance. Yes Yes
ErrorsErrors 可透過階層的方式,向下鑽研至資料庫上發生的 SQL 錯誤。Provides hierarchical drill-down into SQL errors that happened on the databases. Yes Yes
逾時Timeouts 可透過階層的方式,向下鑽研至資料庫上發生的 SQL 逾時。Provides hierarchical drill-down into SQL timeouts that happened on the databases. Yes No
封鎖Blockings 可透過階層的方式,向下鑽研至資料庫上發生的 SQL 封鎖。Provides hierarchical drill-down into SQL blockings that happened on the databases. Yes No
資料庫等候Database waits 可透過階層的方式,向下鑽研至資料庫層級的 SQL 等候統計資料。Provides hierarchical drill-down into SQL wait statistics on the database level. 包含總等候時間及每種等候類型等候時間的摘要。Includes summaries of total waiting time and the waiting time per wait type. Yes Yes
查詢持續時間Query duration 可透過階層的方式,向下鑽研至查詢執行統計資料,例如查詢持續時間、CPU 使用量、資料 IO 使用量、記錄 IO 使用量。Provides hierarchical drill-down into the query execution statistics such as query duration, CPU usage, Data IO usage, Log IO usage. Yes Yes
查詢等候Query waits 可透過階層的方式,依等候類別,向下鑽研至查詢等候統計資料。Provides hierarchical drill-down into the query wait statistics by wait category. Yes Yes

Intelligent Insights 報表Intelligent Insights report

Azure SQL Database Intelligent Insights 可讓您了解所有 Azure SQL 資料庫的效能情況。Azure SQL Database Intelligent Insights lets you know what is happening with performance of all Azure SQL databases. 收集的所有 Intelligent Insights 都可以透過 Insights 檢視方塊視覺化及存取。All Intelligent Insights collected can be visualized and accessed through the Insights perspective.

Azure SQL 分析見解

彈性集區和資料庫報表Elastic pool and Database reports

彈性集區和 SQL Database 都有自己特定的報表,可顯示在指定的時間,針對資源收集的所有資料。Both elastic pools and SQL Databases have their own specific reports that show all the data that is collected for the resource in the specified time.

Azure SQL 分析資料庫

Azure SQL 彈性集區

查詢報表Query reports

您可以透過查詢持續時間和查詢等候檢視方塊,將任何查詢的效能透過查詢報表相互關聯。Through the Query duration and query waits perspectives, you can correlate the performance of any query through the query report. 此報表會比較不同資料庫上的查詢效能,並可讓您輕鬆地找出所選查詢執行速度良好與緩慢的資料庫。This report compares the query performance across different databases and makes it easy to pinpoint databases that perform the selected query well versus ones that are slow.

Azure SQL 分析查詢

PermissionsPermissions

若要使用 Azure SQL 分析,使用者需至少在 Azure 中取得「讀者」角色使用權限。To use Azure SQL Analytics, users need to be granted a minimum permission of the Reader role in Azure. 不過此角色並無法讓使用者取得觀看查詢文字,或執行任何自動調整動作的權限。This role, however, does not allow users to see the query text, or perform any Automatic tuning actions. Azure 中可讓您取得最完整解決方案使用權限的角色為擁有者、參與者、SQL DB 參與者和 SQL Server 參與者。More permissive roles in Azure that allow using the solution to the fullest extent are Owner, Contributor, SQL DB Contributor, or SQL Server Contributor. 您也可能會考慮在入口網站中建立自訂角色,並將使用權限設定為僅限 Azure SQL 分析,不可存取管理其他資源。You also might want to consider creating a custom role in the portal with specific permissions required only to use Azure SQL Analytics, and with no access to managing other resources.

在入口網站中建立自訂角色Creating a custom role in portal

注意

本文已更新為使用新的 Azure PowerShell Az 模組。This article has been updated to use the new Azure PowerShell Az module. AzureRM 模組在至少 2020 年 12 月之前都還會持續收到錯誤 (Bug) 修正,因此您仍然可以持續使用。You can still use the AzureRM module, which will continue to receive bug fixes until at least December 2020. 若要深入了解新的 Az 模組和 AzureRM 的相容性,請參閱新的 Azure PowerShell Az 模組簡介To learn more about the new Az module and AzureRM compatibility, see Introducing the new Azure PowerShell Az module. 如需 Az 模組安裝指示,請參閱安裝 Azure PowerShellFor Az module installation instructions, see Install Azure PowerShell.

我們了解到某些組織會在 Azure 中實施嚴格的使用權限控制,因此請參閱下列 PowerShell 指令碼,它可以在 Azure 入口網站中建立自訂角色「SQL 分析監視人員」,此角色僅擁有使用完整 Azure SQL 分析所需之最低限度讀取和寫入使用權限。Recognizing that some organizations enforce strict permission controls in Azure, find the following PowerShell script enabling creation of a custom role “SQL Analytics Monitoring Operator” in Azure portal with the minimum read and write permissions required to use Azure SQL Analytics to its fullest extent.

在下列指令碼中,請將 “{SubscriptionId}" 取代為您的 Azure 訂用帳戶識別碼,接著以擁有者或參與者角色身分登入 Azure 並執行指令碼。Replace the “{SubscriptionId}" in the below script with your Azure subscription ID, and execute the script logged in as an Owner or Contributor role in Azure.

 Connect-AzAccount
 Select-AzSubscription {SubscriptionId}
 $role = Get-AzRoleDefinition -Name Reader
 $role.Name = "SQL Analytics Monitoring Operator"
 $role.Description = "Lets you monitor database performance with Azure SQL Analytics as a reader. Does not allow change of resources."
 $role.IsCustom = $true
 $role.Actions.Add("Microsoft.SQL/servers/databases/read");
 $role.Actions.Add("Microsoft.SQL/servers/databases/topQueries/queryText/*");
 $role.Actions.Add("Microsoft.Sql/servers/databases/advisors/read");
 $role.Actions.Add("Microsoft.Sql/servers/databases/advisors/write");
 $role.Actions.Add("Microsoft.Sql/servers/databases/advisors/recommendedActions/read");
 $role.Actions.Add("Microsoft.Sql/servers/databases/advisors/recommendedActions/write");
 $role.Actions.Add("Microsoft.Sql/servers/databases/automaticTuning/read");
 $role.Actions.Add("Microsoft.Sql/servers/databases/automaticTuning/write");
 $role.Actions.Add("Microsoft.Sql/servers/databases/*");
 $role.Actions.Add("Microsoft.Sql/servers/advisors/read");
 $role.Actions.Add("Microsoft.Sql/servers/advisors/write");
 $role.Actions.Add("Microsoft.Sql/servers/advisors/recommendedActions/read");
 $role.Actions.Add("Microsoft.Sql/servers/advisors/recommendedActions/write");
 $role.Actions.Add("Microsoft.Resources/deployments/write");
 $role.AssignableScopes = "/subscriptions/{SubscriptionId}"
 New-AzRoleDefinition $role

新角色建立後,請將這個角色指派給需要 Azure SQL 分析使用權限的每一位使用者。Once the new role is created, assign this role to each user that you need to grant custom permissions to use Azure SQL Analytics.

分析資料並建立警示Analyze data and create alerts

Azure SQL 分析中的資料分析以 Log Analytics 語言為基礎,提供您自訂查詢和報告功能。Data analysis in Azure SQL Analytics is based on Log Analytics language for your custom querying and reporting. 請參閱可用的計量和記錄,內有針對收集自資料庫資源可自訂查詢的資料的說明。Find description of the available data collected from database resource for custom querying in metrics and logs available.

解決方案中的自動化警示以寫入的 Log Analytics 查詢為依據,一旦符合條件,該查詢便會觸發警示。Automated alerting in the solution is based on writing a Log Analytics query that triggers an alert upon a condition met. 以下請參考數個可在解決方案中設為警示設定的 Log Analytics 查詢。Find below several examples on Log Analytics queries upon which alerting can be set up in the solution.

建立 Azure SQL Database 的警示Creating alerts for Azure SQL Database

您可以使用來自 Azure SQL Database 資源的資料,輕鬆建立警示You can easily create alerts with the data coming from Azure SQL Database resources. 以下是您可以搭配記錄警示使用的一些實用記錄查詢Here are some useful log queries that you can use with a log alert:

Azure SQL Database 上的高 CPUHigh CPU on Azure SQL Database

AzureMetrics
| where ResourceProvider=="MICROSOFT.SQL"
| where ResourceId contains "/DATABASES/"
| where MetricName=="cpu_percent"
| summarize AggregatedValue = max(Maximum) by bin(TimeGenerated, 5m)
| render timechart

注意

  • 此警示所設定的預先需求是該受監視的資料庫資料流至解決方案的基本計量。Pre-requirement of setting up this alert is that monitored databases stream Basic metrics to the solution.
  • 請將 MetricName 值 cpu_percent 更換為 dtu_consumption_percent,即可改為取得高 DTU 結果。Replace the MetricName value cpu_percent with dtu_consumption_percent to obtain high DTU results instead.

Azure SQL Database 彈性集區上的高 CPUHigh CPU on Azure SQL Database elastic pools

AzureMetrics
| where ResourceProvider=="MICROSOFT.SQL"
| where ResourceId contains "/ELASTICPOOLS/"
| where MetricName=="cpu_percent"
| summarize AggregatedValue = max(Maximum) by bin(TimeGenerated, 5m)
| render timechart

注意

  • 此警示所設定的預先需求是該受監視的資料庫資料流至解決方案的基本計量。Pre-requirement of setting up this alert is that monitored databases stream Basic metrics to the solution.
  • 請將 MetricName 值 cpu_percent 更換為 dtu_consumption_percent,即可改為取得高 DTU 結果。Replace the MetricName value cpu_percent with dtu_consumption_percent to obtain high DTU results instead.

過去 1 小時的平均 Azure SQL Database 儲存體高於 95%Azure SQL Database storage in average above 95% in the last 1 hr

let time_range = 1h;
let storage_threshold = 95;
AzureMetrics
| where ResourceId contains "/DATABASES/"
| where MetricName == "storage_percent"
| summarize max_storage = max(Average) by ResourceId, bin(TimeGenerated, time_range)
| where max_storage > storage_threshold
| distinct ResourceId

注意

  • 此警示所設定的預先需求是該受監視的資料庫資料流至解決方案的基本計量。Pre-requirement of setting up this alert is that monitored databases stream Basic metrics to the solution.
  • 這項查詢需要將警示規則設定為會在有查詢結果 (> 0 個結果) 時引發警示,這表示某些資料庫上有此情況。This query requires an alert rule to be set up to fire off an alert when there exist results (> 0 results) from the query, denoting that the condition exists on some databases. 其輸出中會列出所定義 time_range 內高於 storage_threshold 的資料庫資源。The output is a list of database resources that are above the storage_threshold within the time_range defined.
  • 其輸出中會列出所定義 time_range 內高於 storage_threshold 的資料庫資源。The output is a list of database resources that are above the storage_threshold within the time_range defined.

針對 Intelligent insights 的警示Alert on Intelligent insights

let alert_run_interval = 1h;
let insights_string = "hitting its CPU limits";
AzureDiagnostics
| where Category == "SQLInsights" and status_s == "Active"
| where TimeGenerated > ago(alert_run_interval)
| where rootCauseAnalysis_s contains insights_string
| distinct ResourceId

注意

  • 若要設定此警示,先決條件是受監視的資料庫會將 SQLInsights 診斷記錄串流至解決方案。Pre-requirement of setting up this alert is that monitored databases stream SQLInsights diagnostics log to the solution.
  • 這項查詢需要將警示規則設定為利用和 alert_run_interval 相同的頻率來執行,以避免產生重複結果。This query requires an alert rule to be set up to run with the same frequency as alert_run_interval in order to avoid duplicate results. 請將此規則設定為會在有查詢結果 (> 0 個結果) 時引發警示。The rule should be set up to fire off the alert when there exist results (> 0 results) from the query.
  • 自訂 alert_run_interval 來指定時間範圍,以檢查設定為會將 SQLInsights 記錄串流至解決方案的資料庫上是否發生此情況。Customize the alert_run_interval to specify the time range to check if the condition has occurred on databases configured to stream SQLInsights log to the solution.
  • 自訂 insights_string 以擷取深入解析根本原因分析文字的輸出。Customize the insights_string to capture the output of the Insights root cause analysis text. 在可從現有深入解析使用的解決方案中,其 UI 中會顯示此相同文字。This is the same text displayed in the UI of the solution that you can use from the existing insights. 或者,您也可以使用下列查詢來查看訂用帳戶所產生的所有深入解析文字。Alternatively, you can use the query below to see the text of all Insights generated on your subscription. 請使用查詢的輸出來搜集可供對深入解析設定警示的不同字串。Use the output of the query to harvest the distinct strings for setting up alerts on Insights.
AzureDiagnostics
| where Category == "SQLInsights" and status_s == "Active"
| distinct rootCauseAnalysis_s

建立受控執行個體的警示Creating alerts for Managed Instance

受控執行個體儲存體高於 90%Managed Instance storage is above 90%

let storage_percentage_threshold = 90;
AzureDiagnostics
| where Category =="ResourceUsageStats"
| summarize (TimeGenerated, calculated_storage_percentage) = arg_max(TimeGenerated, todouble(storage_space_used_mb_s) *100 / todouble (reserved_storage_mb_s))
   by ResourceId
| where calculated_storage_percentage > storage_percentage_threshold

注意

  • 若要設定此警示,預先需求是所監視的受控執行個體已對解決方案啟用 ResourceUsageStats 記錄的串流。Pre-requirement of setting up this alert is that monitored Managed Instance has the streaming of ResourceUsageStats log enabled to the solution.
  • 這項查詢需要將警示規則設定為會在有查詢結果 (> 0 個結果) 時引發警示,這表示受控執行個體上有此情況。This query requires an alert rule to be set up to fire off an alert when there exist results (> 0 results) from the query, denoting that the condition exists on the Managed Instance. 輸出是受控執行個體上的儲存體耗用量百分比。The output is storage percentage consumption on the Managed Instance.

過去 1 小時的受控執行個體 CPU 平均耗用量高於 95%Managed Instance CPU average consumption is above 95% in the last 1 hr

let cpu_percentage_threshold = 95;
let time_threshold = ago(1h);
AzureDiagnostics
| where Category == "ResourceUsageStats" and TimeGenerated > time_threshold
| summarize avg_cpu = max(todouble(avg_cpu_percent_s)) by ResourceId
| where avg_cpu > cpu_percentage_threshold

注意

  • 若要設定此警示,預先需求是所監視的受控執行個體已對解決方案啟用 ResourceUsageStats 記錄的串流。Pre-requirement of setting up this alert is that monitored Managed Instance has the streaming of ResourceUsageStats log enabled to the solution.
  • 這項查詢需要將警示規則設定為會在有查詢結果 (> 0 個結果) 時引發警示,這表示受控執行個體上有此情況。This query requires an alert rule to be set up to fire off an alert when there exist results (> 0 results) from the query, denoting that the condition exists on the Managed Instance. 輸出是受控行個體上在定義期間中的平均 CPU 使用率百分比耗用量。The output is average CPU utilization percentage consumption in defined period on the Managed Instance.

價格Pricing

雖然可免費使用解決方案,但診斷資料的使用量若超過每個月所配置的免費資料擷取單位,則需付費,請參閱 Log Analytics 定價While the solution is free to use, consumption of diagnostics telemetry above the free units of data ingestion allocated each month applies, see Log Analytics pricing. 所提供的免費資料擷取單位可讓您每個月免費監視多個資料庫。The free units of data ingestion provided enable free monitoring of several databases each month. 請注意,相較於閒置的資料庫,較繁重工作負載的更多作用中資料庫會擷取更多資料。Note that more active databases with heavier workloads ingest more data versus idle databases. 您可以藉由選取 Azure SQL 分析導覽功能表上的 OMS 工作區,然後選取 [使用量和估計成本],輕鬆地監視您解決方案中的資料擷取耗用。You can easily monitor your data ingestion consumption in the solution by selecting OMS Workspace on the navigation menu of Azure SQL Analytics, and then selecting Usage and Estimated Costs.

後續步驟Next steps