Fabric Real-Time Intelligence Performance remediate
Systematic toolkit for diagnosing and resolving performance issues across the Microsoft Fabric Real-Time Intelligence stack: Eventhouse, KQL databases, Eventstream, ingestion pipelines, and capacity management.
When to Use This Skill
- Eventhouse queries running slowly or timing out
- Ingestion latency or failures into KQL databases
- Eventstream throughput bottlenecks or backlog growth
- Capacity throttling errors (HTTP 430, TooManyRequestsForCapacity)
- High CPU, memory, or cache utilization on Eventhouse
- Materialized view lag or freshness issues
- Always-On and minimum consumption sizing decisions
- Workspace monitoring setup and dashboard interpretation
- KQL query optimization for Real-Time Intelligence workloads
Prerequisites
- Microsoft Fabric workspace with Contributor or higher permissions
- Workspace monitoring enabled (for query/ingestion logs)
- Fabric Capacity Metrics app installed (for capacity-level analysis)
- KQL Queryset or Eventhouse query editor access
Step-by-Step Workflows
Workflow 1: Diagnose Slow KQL Queries
- Enable workspace monitoring if not already active. See workspace-monitoring.md
- Identify expensive queries using the diagnostic script: Run diagnose-slow-queries.kql against the monitoring Eventhouse
- Analyze query patterns — filter by Top CPU Time, Top Duration, or Memory Peak
- Apply KQL optimization rules from kql-optimization.md
- Validate improvement by re-running the query and comparing duration/CPU metrics
Workflow 2: Troubleshoot Ingestion Issues
- Check ingestion results logs using diagnose-ingestion.kql
- Review Eventstream data insights — check IncomingMessages, OutgoingMessages, BackloggedInputEvents, and WatermarkDelay metrics
- Identify failure patterns — deserialization errors, schema mismatches, throttling
- Apply throughput tuning per ingestion-remediate.md
- Validate pipeline health by monitoring runtime logs on source and destination nodes
Workflow 3: Resolve Capacity Throttling
- Open the Fabric Capacity Metrics app — filter to your capacity and workspace
- Check Eventhouse UpTime CU consumption — identify if a single Eventhouse dominates
- Run capacity diagnostics using diagnose-capacity.kql
- Evaluate sizing options: Always-On minimum consumption, cache policy adjustments, or SKU upgrade
- Apply recommendations from capacity-and-sizing.md
remediate Quick Reference
| Symptom | First Check | Script |
|---|---|---|
| Slow queries | Workspace Monitoring → EH Queries tab | diagnose-slow-queries.kql |
| Query throttling (HTTP 430) | Capacity Metrics app → CU utilization | diagnose-capacity.kql |
| Ingestion failures | Eventstream → Runtime logs tab | diagnose-ingestion.kql |
| High ingestion latency | Eventstream → Data insights → WatermarkDelay | diagnose-ingestion.kql |
| Materialized view stale | .show materialized-views command | diagnose-slow-queries.kql |
| Cold storage scans | Cache policy vs query time range | diagnose-capacity.kql |
| Eventhouse wake-up latency | Always-On setting disabled | capacity-and-sizing.md |
| Eventstream backlog growing | Throughput setting mismatch | ingestion-remediate.md |
References
- KQL Query Optimization Guide — Best practices for writing performant KQL
- Ingestion remediate Guide — Eventstream, batching, and streaming diagnostics
- Capacity and Sizing Guide — Always-On, cache policies, CU consumption
- Workspace Monitoring Setup — Enabling and using monitoring tables and dashboards
- KQL Best Practices (Microsoft)
- Eventhouse Compute Observability
- Eventstream Monitoring
- Fabric Capacity Metrics App