KQL
Articles in the KQL category (19).
Articles in the KQL category (19).
- Application Insights: long SQL dependencies executed repeatedly — KQL query listing SQL calls longer than one second that ran at least 10 times in the last hour.
- Azure SQL: find long queries in the audit logs with KQL — Two KQL queries on the SQLSecurityAuditEvents category: number of long statements per database, then long statements grouped by text.
- KQL for Azure SQL operations: CPU, waits, queries, errors, storage and geo-replication — A KQL toolbox for Azure SQL Database: CPU, waits, Query Store, errors, failed logins, storage limit wall and replication heatmap.
- KQL queries to monitor Azure SQL (workers, storage, errors, I/O) — Log Analytics queries on AzureMetrics and AzureDiagnostics to track workers, storage, errors and PAGEIOLATCH waits.
- KQL queries to monitor Azure SQL Database — Log Analytics queries (AzureMetrics, AzureDiagnostics, AzureActivity) to track Azure SQL metrics, deadlocks, failed connections and long-running operations.
- KQL queries: Azure SQL sessions (AzureMetrics) — KQL queries to track the sessions_count metric of Azure SQL Database in the AzureMetrics table of Log Analytics.
- KQL: Azure SQL wait statistics in Log Analytics — KQL queries to analyse wait stats of an Azure SQL database or elastic pool in 5-minute bins.
- KQL: find the accounts hit hardest by latency in Application Insights — KQL queries on the requests table and performanceBucket to spot slow requests per account.
- KQL: finding long transactions in Azure SQL Database — KQL queries on AzureDiagnostics to list a transaction's statements and detect long transactions.
- KQL: ingestion and usage statistics in Log Analytics — KQL queries to measure data ingested into Log Analytics, notably Azure SQL audit logs.
- KQL: LCK_M_S lock waits per Azure SQL database — KQL query on AzureDiagnostics to track shared lock waits per database, per minute.
- KQL: Log Analytics ingestion volume and daily exceptions — KQL queries for billable ingestion per table and application exceptions per role and day.
- KQL: resource governor waits in Azure SQL Database — KQL queries on AzureDiagnostics to track governor and log rate waits per server and elastic pool.
- KQL: slow Application Insights requests with their dependencies — KQL query listing long requests and the details of their dependencies (SQL, Service Bus).
- KQL: SQL dependency durations by performance bucket — Application Insights KQL query grouping SQL dependencies by day and duration bucket.
- Monitoring Azure Batch with KQL and Grafana — KQL queries over AzureDiagnostics for failed, active and pending tasks, success rate, tasks per job and per application, and how to use them in Grafana.
- Monitoring Azure SQL failover groups with KQL and T-SQL — Replication lag, role per database, databases missing from the group and failover alerts with KQL and T-SQL queries.
- Who blocked my connection? Investigating denied Azure SQL connections with Azure Firewall logs in KQL — Find the rule and action denying a connection to Azure SQL using AZFWNetworkRule and AzureDiagnostics, handling time zones and ingestion lag.
- Who changed what? The Azure Activity Log in KQL — Find who scaled a pool or changed a failover group or firewall rule with AzureActivity, plus Resource Graph change analysis.