KQL
Articles in the KQL category (14).
Articles in the KQL category (14).
- 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 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.