skills.rest
PatrickGallucci
PatrickGallucciCOMMUNITY
Explore all skills by this author →
GitHub

fabric-spark-compute-perf-remediate

Diagnose and remediate performance issues across Fabric Spark compute and Delta Lake tables.

16|1|Updated Feb 10, 2026
Search Tags:#optimize#diagnose#spark#fabric#delta-lake#vacuum
One-click install
npx skills add https://github.com/PatrickGallucci/fabric-skills --skill fabric-spark-compute-perf-remediate
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: fabric-spark-compute-perf-remediate
Source: https://github.com/PatrickGallucci/fabric-skills/tree/main/skills/fabric-spark-compute-perf-remediate
Command: npx skills add https://github.com/PatrickGallucci/fabric-skills --skill fabric-spark-compute-perf-remediate

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires Az.Accounts, and includes scripts (resource) and references (resource) components.

What problem does it solve?

Systematic remediation toolkit for diagnosing and resolving performance issues across Microsoft Fabric Spark compute, Delta Lake tables, and Lakehouse workloads.

Core Features & Use Cases

  • Comprehensive triage and diagnostics for Spark compute, Delta health, and maintenance schedules
  • Ready-to-run scripts for assessing Delta table health, capacity status, and performing maintenance
  • Reference guides and a diagnostic notebook template to guide remediation

Quick Start

Install the skill and run the perf-diagnostic notebook to begin diagnostics.

Frequently Asked Questions about fabric-spark-compute-perf-remediate

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I diagnose slow Fabric Spark compute and Delta Lake performance issues?▼

Fabric Spark compute and Delta Lake performance issues are diagnosed by running the provided perf-diagnostic PySpark notebook alongside PowerShell 7+ scripts to assess table health, capacity status, and maintenance schedules.

What causes out-of-memory errors and capacity throttling in Fabric Spark jobs?▼

Out-of-memory errors and capacity throttling in Fabric Spark jobs typically stem from poorly optimized Lakehouse workloads, streaming inputs, or SQL analytics endpoint queries, which this Skill's diagnostic toolkit systematically identifies and remediates.

Do I need PowerShell and PySpark to troubleshoot Fabric Spark notebook latency?▼

Yes, troubleshooting Fabric Spark notebook latency requires PowerShell 7+ for diagnostic scripts and PySpark for notebook-based diagnostics, alongside access to a Fabric workspace with Data Engineering enabled.

What is the best way to resolve Delta Lake small-file problems in a Fabric Lakehouse?▼

The best way to resolve Delta Lake small-file problems in a Fabric Lakehouse is by running maintenance scripts, such as Vacuum operations, provided within the toolkit to assess table health and execute necessary remediation.

Why does my Fabric Spark job experience latency when processing Delta tables?▼

Fabric Spark job latency when processing Delta tables often occurs due to small-file problems, suboptimal compute configurations, or skipped maintenance schedules, which the diagnostic scripts and reference guides help identify and resolve.

Related Skills

Explore More Data & Analytics Skills→
weiflycc-cmdweiflycc-cmd

spark-authoring-cli

Manage Microsoft Fabric Spark workloads and author PySpark, Scala, and SQL notebooks via REST API patterns.

Community
Advanced
PatrickGallucciPatrickGallucci
16

fabric-lakehouse-perf-remediate

Diagnose and remediate Microsoft Fabric Lakehouse performance issues across Delta tables and Spark configurations.

Community
Advanced
patrikboroschpatrikborosch
14

e2e-medallion-architecture

Automate Bronze/Silver/Gold medallion lakehouse pipelines in Microsoft Fabric.

Community
Advanced
abdullah1854abdullah1854
1

fabric-helper

Generate Delta Lake and Spark SQL queries for Fabric Lakehouse and Warehouse.

Community
Intermediate