skills.rest
microsoft
microsoftOFFICIAL
Explore all skills by this author ā†’
Websiteš•@OpenAtMicrosoftGitHub

sqldw-operations-cli

Analyze Fabric Data Warehouse performance and diagnostics via CLI.

952|267|Updated Feb 17, 2026
Search Tags:#performance#monitoring#diagnostics#fabric#data-warehouse#sqlcmd#queryinsights
One-click install
npx skills add https://github.com/microsoft/skills-for-fabric --skill sqldw-operations-cli
Or copy as Structured Prompt for Agentā–¼
Please help me install this Agent Skill.
Skill: sqldw-operations-cli
Source: https://github.com/microsoft/skills-for-fabric/tree/main/plugins/fabric-operations/skills/sqldw-operations-cli
Command: npx skills add https://github.com/microsoft/skills-for-fabric --skill sqldw-operations-cli

SYSTEM DOCUMENTATION & REQUIREMENTS

šŸ’” This Skill includes references (resource) components.

What problem does it solve?

Analyze Fabric Data Warehouse performance and diagnostics using a CLI-driven workflow to identify slow queries, CPU hotspots, and heavy data scans, enabling precise optimization interventions.

Core Features & Use Cases

  • Read-only diagnostics: Surface slow queries, high CPU consumers, and data-scan hotspots without modifying data.
  • Evidence-based optimization: Provide actionable guidance for tuning queries, improving data layout, and evaluating clustering opportunities.
  • Use Case: When a Fabric Data Warehouse shows degraded performance, surface top resource consumers and baseline shifts to guide remediation strategies.

Quick Start

Run the CLI against your Fabric workspace to surface slow queries and CPU hotspots.

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 a Fabric Data Warehouse?ā–¼

Yes, you can identify Fabric Data Warehouse CPU hotspots using a read-only CLI workflow. By leveraging az rest and sqlcmd commands, it surfaces high CPU consumers and data-scan hotspots to guide precise optimization interventions.

What is the best way to monitor Fabric Data Warehouse performance using command line tools?ā–¼

Yes, you can analyze Fabric Data Warehouse performance using a read-only CLI workflow. By executing read-only diagnostic queries via sqlcmd and az rest, it safely surfaces slow queries and resource bottlenecks without modifying any warehouse data.

Do I need specific environment authentication steps to run diagnostics on a Fabric Data Warehouse?ā–¼

To troubleshoot degraded Fabric Data Warehouse performance, execute read-only CLI diagnostics against your workspace. This surfaces slow queries, high CPU consumers, and data-scan hotspots, providing evidence-based guidance for query tuning and data layout improvements.

Does this Fabric Data Warehouse diagnostics workflow require modifying the target database?ā–¼

No, this Fabric Data Warehouse diagnostics workflow does not require modifying the target database. It strictly performs read-only diagnostic queries to surface slow queries and resource bottlenecks for admin and data-ops scenarios.

How do I surface heavy data scans in a Fabric workspace for data-ops scenarios?ā–¼

To surface heavy data scans in a Fabric workspace for data-ops scenarios, run a CLI-based workflow using sqlcmd and jq. It identifies heavy data scans and provides actionable guidance for evaluating clustering opportunities.

Related Skills

Explore More Data & Analytics Skillsā†’
microsoftmicrosoft
952

sqldw-consumption-cli

Query read-only T-SQL against Fabric Data Warehouse, Lakehouse, and Mirrored Databases via CLI.

Official
Intermediate
ntaksh42ntaksh42
1

performance-analyzer

Analyze code performance and detect bottlenecks in algorithms, queries, and resource usage.

Community
Intermediate
mf-dynatracemf-dynatrace

dt-obs-hosts

Monitor and analyze host and process metrics using DQL.

Community
Advanced
wardawgmalviciouswardawgmalvicious
2

fabric-monitoring

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

Community
Advanced