Azure Resource Graph Explorer

通过C#的Microsoft Certified: Azure Developer Associate认证 #生活技巧# #工作学习技巧# #工作技能认证#

Hi @Suthii09

Thanks for the question and using MS Q&A platform

The DTU percentage is a measure of performance for Azure SQL databases, and it's usually tracked using Azure Monitor or Azure Metrics. However, Azure Resource Graph Explorer is mainly used for checking information about resources (like their details and settings) and doesn't provide performance data like DTU usage

To obtain DTU usage, please query Azure Monitor metrics instead of Azure Resource Graph. While Azure Resource Graph Explorer is excellent for querying resource properties, it is not suitable for performance metrics like DTU consumption.

You can use Azure Monitor to get DTU consumption. Here’s a simple query example using Azure Metrics Explorer to get DTU usage:

AzureMetrics

| where Resource == "SQL Database" and ResourceName == "<Your Database Name>" | where ResourceType == "DATABASE" | where MetricName == "dtu_consumption" | summarize avg(Total) by bin(TimeGenerated, 1h), ResourceName

If you need to list databases and their related properties, such as server name and database type, you can utilize Azure Resource Graph Explorer. For instance:

Resources

| where type == "microsoft.sql/servers/databases" | project name, resourceGroup, location, serverName, sku

Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

网址：Azure Resource Graph Explorer https://klqsh.com/news/view/147859

相关内容

How to use the Azure Resource Graph Explorer to inventory resources in MS Azure – Victor Villar's Blog
Microsoft Azure Get Storage Account Information using Resource Graph
Quickstart: Run Resource Graph query using Azure CLI
Azure Graph Query for Expiring certificates or secrets in App Registration
Starter query samples
How to Get Help with File Explorer in Windows 11/10
File Explorer in Windows
Get Help with File Explorer in Windows 11
Where Is “Quick Access” In Windows 11 File Explorer?
How to Use File Explorer in Windows 11: A Comprehensive Guide

随便看看