Individual skill
fabric-onelake-perf-remediate
Diagnose and resolve Microsoft Fabric OneLake performance issues including slow queries, cold cache latency, small file problems, Delta table fragmentation, V-Order optimization, Spark throttling, capacity SKU sizing, and cross-region data access. Use when remediate OneLake read/write performance, lakehouse query slowness, Direct Lake fallback, table maintenance failures, Spark concurrency limits, warehouse cold starts, or optimizing Delta parquet file layouts. Supports PowerShell, T-SQL, and Spark SQL diagnostic workflows.
skills/fabric-onelake-perf-remediate/SKILL.md
Source commit cee03dc1199cd2a9765b439fa41930d480e5989d
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- Yes
- Repository scan complete
- No
- Skill scan complete
- No
- Observed behavior
- Local scripts
- Last checked
- Nov 11, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 17
- Repository last updated
- Jun 7, 2026
- License
- MIT
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
- claude Repository topic
- claude-skills Repository topic
- copilot Repository topic
- copilot-skills Repository topic
- fabric Repository topic
- microsoft-fabric Repository topic
- data Derived category
- data-databases Derived category
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Browse files
LICENSE.txtdoc · 11,358 bytesSKILL.mdcore · 7,579 bytesSKILL.mdcore · 7,579 bytesSKILL.mdcore · 7,579 bytesreferences/capacity-sku-reference.mddoc · 3,077 bytesreferences/cold-cache-diagnostics.mddoc · 4,440 bytesreferences/direct-lake-troubleshooting.mddoc · 4,057 bytesreferences/onelake-consumption-optimization.mddoc · 8,008 bytesreferences/onelake-diagnostics-guide.mddoc · 7,848 bytesreferences/onelake-shortcuts-performance.mddoc · 7,985 bytesreferences/table-maintenance-workflow.mddoc · 5,056 bytesreferences/v-order-decision-guide.mddoc · 4,881 bytesscripts/Test-OneLakeHealth.ps1runs · 11,626 bytesscripts/region-latency-test.ps1runs · 5,131 bytesscripts/run-table-maintenance.ps1runs · 7,410 bytesscripts/spark-capacity-check.ps1runs · 5,139 bytesscripts/table-health-check.ps1runs · 5,101 bytestemplates/diagnostic-report.mddoc · 2,161 bytestemplates/onelake-performance-checklist.mddoc · 4,902 bytes
Read excerpt
# OneLake Performance remediate
Systematic diagnostic and remediation toolkit for Microsoft Fabric OneLake performance issues. Covers the full stack from capacity-level throttling down to individual Delta table file layout problems.
## When to Use This Skill
- OneLake read or write operations are slow or timing out
- Lakehouse or warehouse queries have unexpectedly high latency
- Spark jobs are being throttled with HTTP 430 errors
- Delta tables have accumulated many small files (small file problem)
- Direct Lake semantic models are falling back to DirectQuery
- Cold cache performance is significantly slower than warm cache
- Cross-region data access is adding network latency
- V-Order is not applied or needs to be enabled/disabled
- Table maintenance (OPTIMIZE, VACUUM) is failing or not improving performance