Lesson Learned #321:Useful Kusto Monitoring Queries for Azure SQL Database and Elastic Database Pool

[Guest Jose_Manuel_Jurado]

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!

 

Continue reading...