Hi there,
I’m using azure mysql and send the slow query to log analytics and example KQL query was :
AzureDiagnostics
| where LogicalServerName_s == ‘ci1mysql’
| where Category == ‘MySqlSlowLogs’
| where query_time_d > 10
| project TimeGenerated, LogicalServerName_s, event_class_s, start_time_t , query_time_d, sql_text_s
| order by query_time_d desc
| take 10
How can I create the dashboard for this query?
Thank you in advance