fabric-data-agent-perf-remediatelisted

# Fabric Data Agent Performance remediate Systematic toolkit for diagnosing and resolving performance issues in Microsoft Fabric Data Agents, Operations Agents, and their underlying Spark compute and data source infrastructure. ## When to Use This Skill - Data Agent responses are slow or timing out - Agent-generated SQL/KQL/DAX queries return errors or produce incorrect results - Spark session startup takes longer than expected (>10 seconds) - Capacity throttling errors (HTTP 430) during agent workloads - Operations Agent playbooks fail to execute or trigger actions - Data source connections are unreliable or stale - Example queries fail validation against schema - Resource profiles need tuning for agent-specific workloads - Table maintenance (VOrder, bin-compaction, vacuum) is overdue - Autoscale Billing configuration needs optimization ## Prerequisites - **Access**: Fabric workspace Contributor or Admin role - **Tools**: PowerShell 7+, Fabric REST API access (Microsoft Entra token) - **Endpoints**: `https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items` - **Monitoring**: Access to Fabric Admin Portal and Azure Cost Analysis - **Optional**: Azure subscription admin for SKU resizing and Autoscale Billing ## Diagnostic Decision Tree ``` Agent performance issue reported ├── Slow response times? │ ├── First query after idle? → Spark session startup (see Workflow 1) │ ├── All queries slow? → Resource profile mismatch (see Workflow 2) │ └── Intermittent s