This post has been republished via RSS; it originally appeared at: Microsoft Tech Community - Latest Blogs - .
You could find here useful Kusto queries to monitor Elastic Database Pool and Azure SQL Databases standalone.
CPU Percentage
AzureMetrics
| where ResourceProvider == "MICROSOFT.SQL"
| where TimeGenerated >= ago(1d)
| where MetricName in ('cpu_percent')
| parse _ResourceId with * "/microsoft.sql/servers/" Resource
| summarize CPU_percent = max(Maximum) by Resource, MetricName
Data IO percentage.
AzureMetrics
| where ResourceProvider == "MICROSOFT.SQL"
| where TimeGenerated >= ago(1d)
| where MetricName in ('physical_data_read_percent')
| parse _ResourceId with * "/microsoft.sql/servers/" Resource
| summarize Physical_data_percent = max(Maximum) by Resource, MetricName
Log IO percentage.
AzureMetrics
| where ResourceProvider == "MICROSOFT.SQL"
| where TimeGenerated >= ago(1d)
| where MetricName in ('log_write_percent')
| parse _ResourceId with * "/microsoft.sql/servers/" Resource
| summarize LOG_Write_percent = max(Maximum) by Resource, MetricName
Enjoy!