skills.rest
wardawgmalvicious
wardawgmalviciousCOMMUNITY
Explore all skills by this author →
GitHub

fabric-monitoring

Monitor and diagnose Fabric Warehouse queries using queryinsights schema and DMVs.

2|1|Updated May 5, 2026
Search Tags:#monitoring#diagnosis#performance analysis#fabric#query insights
One-click install
npx skills add https://github.com/wardawgmalvicious/claude-config --skill fabric-monitoring
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: fabric-monitoring
Source: https://github.com/wardawgmalvicious/claude-config/tree/main/skills/fabric-monitoring
Command: npx skills add https://github.com/wardawgmalvicious/claude-config --skill fabric-monitoring

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses the challenge of monitoring and diagnosing Fabric Warehouse queries, providing tools for tracking, performance analysis, and troubleshooting.

Core Features & Use Cases

  • Query Tracking: Track and label queries for performance analysis and troubleshooting.
  • Query Insights: Utilize the queryinsights schema for detailed query history and performance metrics.
  • DMVs for Live State: Use DMVs to inspect active connections, sessions, and requests.
  • Endpoint Metadata Sync: Diagnose slow/stale Lakehouse SQLEP reads using SQL endpoint metadata sync.
  • Result Set Caching: Analyze query caching and performance.
  • Statistics: Monitor and maintain statistics for query performance.
  • Use Case: A data professional can use this Skill to monitor and optimize a complex Fabric Warehouse query that is running slow, identify the root cause, and apply necessary optimizations.

Quick Start

Use the fabric-monitoring skill to track and analyze the performance of a Fabric Warehouse query labeled 'CriticalQuery'.

Frequently Asked Questions about fabric-monitoring

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

FAQPage Schema
How do I monitor Fabric Warehouse query performance?▼

You can monitor Fabric Warehouse query performance by tracking and labeling queries to analyze history, caching, and statistics. This utilizes the queryinsights schema and DMVs to provide detailed real-time performance metrics for troubleshooting.

How do I troubleshoot slow Fabric Warehouse queries?▼

Troubleshoot slow Fabric Warehouse queries by utilizing the queryinsights schema and DMVs to inspect active connections and sessions. You can identify root causes using performance metrics and apply necessary optimizations.

How does the queryinsights schema work for query analysis?▼

The queryinsights schema provides detailed query history and performance metrics for Fabric Warehouse analysis. It allows data professionals to track, label, and analyze query execution to identify performance bottlenecks.

Can I use DMVs to inspect active Fabric Warehouse sessions?▼

Yes, you can use Dynamic Management Views to inspect the live state of Fabric Warehouse. DMVs allow you to monitor active connections, sessions, and real-time requests for performance diagnosis.

Do I need SQL query execution capabilities to diagnose Lakehouse SQLEP reads?▼

Yes, diagnosing slow or stale Lakehouse SQLEP reads requires SQL query execution capabilities and Fabric Warehouse access. This allows you to utilize SQL endpoint metadata sync for accurate performance analysis.

What is the best way to analyze result set caching in Fabric Warehouse?▼

Analyzing result set caching in Fabric Warehouse is best handled by monitoring query performance and statistics. This approach identifies how caching impacts execution speed and overall query efficiency.

Related Skills

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

sqldw-operations-cli

Diagnoses Microsoft Fabric Data Warehouse performance issues via CLI and built-in queryinsights views.

Community
Advanced
musher-devmusher-dev

auditing-operational-health

Audit PostgreSQL operational health with diagnostic SQL queries and remediation strategies.

Official
Advanced
tonone-aitonone-ai
69

lens-recon

Scan workspace analytics artifacts and generate a structured coverage map.

Official
Advanced
patrikboroschpatrikborosch
14

sqldw-operations-cli

Diagnose Microsoft Fabric Data Warehouse performance bottlenecks with read-only T-SQL queries.

Community
Intermediate