skills.rest
patrikborosch
patrikboroschCOMMUNITY
Explore all skills by this author →
GitHub

sqldw-operations-cli

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

14|3|Updated Mar 13, 2026
Search Tags:#query analysis#sqlcmd#performance diagnostics#cache analysis#fabric data warehouse#clustering optimization#sql pool pressure
One-click install
npx skills add https://github.com/patrikborosch/AnalyticsPlatformAgents --skill sqldw-operations-cli-patrikborosch
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqldw-operations-cli
Source: https://github.com/patrikborosch/AnalyticsPlatformAgents/tree/main/creator/skills/sqldw-operations-cli
Command: npx skills add https://github.com/patrikborosch/AnalyticsPlatformAgents --skill sqldw-operations-cli-patrikborosch

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Manually diagnosing Microsoft Fabric Data Warehouse performance bottlenecks—including slow queries, SQL pool pressure events, cold cache issues, and suboptimal data clustering—is time-consuming and requires deep platform-specific knowledge of queryinsights views and system DMVs. This Skill automates the analysis of built-in diagnostic metrics to quickly identify root causes and actionable optimization steps.

Core Features & Use Cases

  • Performance Diagnostics: Analyze slow queries, top CPU/storage resource consumers, user query patterns, and performance regressions against historical baselines using read-only T-SQL queries executed via sqlcmd.
  • Deep Root-Cause Analysis: Identify SQL pool pressure windows, cache warmth inefficiencies, and query plan bottlenecks to pinpoint why workloads are experiencing degraded performance.
  • Clustering Optimization: Generate data clustering key recommendations for high-scanned tables, with step-by-step guidance for implementing clustering via CTAS to improve query performance. Use case: A data engineer noticing warehouse slowdowns can use this Skill to quickly identify the top slowest queries, check for concurrent pressure events, and get recommended clustering keys for high-volume fact tables without manually writing complex diagnostic queries.

Quick Start

Use the sqldw-operations-cli skill to analyze the slowest queries in your Fabric Data Warehouse over the last 24 hours and get actionable optimization recommendations.

Frequently Asked Questions about sqldw-operations-cli

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

FAQPage Schema
How do I diagnose slow queries in Microsoft Fabric Data Warehouse?▼

To diagnose slow queries in Microsoft Fabric Data Warehouse, you can analyze 30-day historical metrics from queryinsights views using read-only T-SQL queries executed via sqlcmd. This approach identifies top resource consumers and performance regressions without modifying warehouse data.

What is the best way to identify SQL pool pressure events in Fabric DW?▼

Identifying SQL pool pressure events in Fabric DW involves analyzing system DMVs and queryinsights historical metrics to pinpoint concurrent workload bottlenecks. This root-cause analysis reveals specific pressure windows causing degraded performance.

How do I optimize data clustering for high-volume tables in Fabric Data Warehouse?▼

Optimizing data clustering for Fabric Data Warehouse tables involves generating clustering key recommendations for highly scanned tables. You receive step-by-step guidance to implement these clustering optimizations via CTAS to improve query performance.

Can I use sqlcmd with Entra ID authentication for Fabric DW performance diagnostics?▼

Yes, you can use sqlcmd with Entra ID authentication to execute read-only T-SQL queries for Fabric DW performance diagnostics. This setup accesses queryinsights metrics and system DMVs for non-destructive monitoring and root-cause analysis.

Why does my Fabric Data Warehouse experience cold cache inefficiencies?▼

Fabric Data Warehouse cold cache inefficiencies occur when workloads experience degraded performance due to cache warmth issues. Analyzing queryinsights views and system DMVs helps pinpoint these cache warmth bottlenecks and identify actionable optimization steps.

Does diagnosing Fabric DW performance bottlenecks modify warehouse data?▼

No, diagnosing Fabric DW performance bottlenecks does not modify warehouse data because the process strictly executes read-only T-SQL queries. It accesses 30-day historical metrics and system DMVs for non-destructive diagnostics and root-cause analysis.

Related Skills

Explore More Data & Analytics Skills→
rritecrritec
3

sqldw-consumption-cli

Execute read-only T-SQL queries against Microsoft Fabric SQL endpoints from the command line.

Community
Advanced
rritecrritec
3

sqldw-operations-cli

Diagnose Microsoft Fabric Data Warehouse performance using queryinsights history and system DMVs.

Community
Advanced
camoneartcamoneart
5

grafana-dashboards

Design and deploy Grafana dashboards for real-time system and application metrics.

Community
Intermediate
weiflycc-cmdweiflycc-cmd

sqldw-operations-cli

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

Community
Advanced