通过命令行分析 Fabric 数据仓库性能瓶颈并给出优化建议。
复制安装指令,让 AI 自动完成配置 · 推荐新手
请帮我安装 askskill 上的 "sqldw-operations-cli" 技能: 1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/skills/sqldw-operations-cli/SKILL.md 2. 保存为 ~/.claude/skills/sqldw-operations-cli/SKILL.md 3. 装好后重载技能,告诉我可以用了
请用 sqlcmd 和 queryinsights 视图分析这个 Fabric Data Warehouse 最近 24 小时最慢的查询,按执行时间、CPU 和扫描量排序,并总结最可能的性能瓶颈。
返回慢查询清单、关键性能指标、瓶颈判断以及可执行的优化建议。
帮我检查这个仓库最近一周的 SQL pool pressure window 和 pressure events,找出高压力时段、主要资源消耗查询,并判断是否存在并发或资源争用问题。
输出压力时间窗口、资源热点查询、问题成因分析和缓解措施建议。
基于当前查询模式、表访问分布和历史性能基线,评估哪些表适合调整 clustering key,并对比近期性能是否较基线出现退化。
给出候选表、聚类键建议、基线对比结果以及优化优先级排序。
Update Check — ONCE PER SESSION (mandatory) The first time this skill is used in a session, run the check-updates skill before proceeding.
- GitHub Copilot CLI / VS Code: invoke the
check-updatesskill.- Claude Code / Cowork / Cursor / Windsurf / Codex: compare local vs remote package.json version.
- Skip if the check was already performed earlier in this session.
CRITICAL NOTES
- To find the workspace details (including its ID) from workspace name: list all workspaces and, then, use JMESPath filtering
- To find the item details (including its ID) from workspace ID, item type, and item name: list all items of that type in that workspace and, then, use JMESPath filtering
This skill provides performance analysis, deep diagnostics, and optimization guidance for Microsoft Fabric Data Warehouse via sqlcmd and the built-in queryinsights views. All queries are read-only.
For tool installation and authentication setup, see COMMON-CLI.md § Authentication Recipes and COMMON-CLI.md § SQL / TDS Data-Plane Access.
Monitoring-specific requirements:
queryinsights views)queryinsights views retain 30 days; data appears with up to 15 min delay)| Task | Reference | Notes |
|---|---|---|
| Finding Workspaces and Items in Fabric | COMMON-CLI.md § Finding Workspaces and Items in Fabric | Mandatory — READ link first [needed for finding workspace id by its name or item id by its name, item type, and workspace id] |
| Fabric Topology & Key Concepts | COMMON-CORE.md § Fabric Topology & Key Concepts | |
| Environment URLs | COMMON-CORE.md § Environment URLs | |
| Authentication & Token Acquisition | COMMON-CORE.md § Authentication & Token Acquisition | Wrong audience = 401; read before any auth issue |
| Core Control-Plane REST APIs | COMMON-CORE.md § Core Control-Plane REST APIs | Includes pagination, LRO polling, and rate-limiting patterns |
| Capacity Management | COMMON-CORE.md § Capacity Management | |
| Gotchas, Best Practices & Troubleshooting (Platform) | COMMON-CORE.md § Gotchas, Best Practices & Troubleshooting | |
| Tool Selection Rationale | COMMON-CLI.md § Tool Selection Rationale | |
| Authentication Recipes | COMMON-CLI.md § Authentication Recipes | az login flows and token acquisition |
Fabric Control-Plane API via az rest | COMMON-CLI.md § Fabric Control-Plane API via az rest | Always pass --resource; includes pagination and LRO helpers |
| SQL / TDS Data-Plane Access | COMMON-CLI.md § SQL / TDS Data-Plane Access | sqlcmd (Go) connect, query, CSV export |
| Gotchas & Troubleshooting (CLI-Specific) | COMMON-CLI.md § Gotchas & Troubleshooting (CLI-Specific) | az rest audience, shell escaping, token expiry |
| Quick Reference | COMMON-CLI.md § Quick Reference | az rest template + token audience/tool matrix |
…
帮助将 Databricks 笔记本、作业与数据路径系统迁移到 Microsoft Fabric。
帮助你查询、解析并核查 Microsoft Fabric Eventstream 实时管道配置与状态。
用 PySpark 与 Livy 会话交互分析 Lakehouse 数据并完成高级处理
帮助用户对 Fabric Eventhouse 执行 KQL 查询、分析时序数据并查看表结构与摄取状态。
执行 DAX 查询并检查 Power BI 语义模型元数据,快速获取表、列、度量与关系信息。
帮助用户查询 Fabric Eventhouse 的 KQL 数据,并进行实时与时序分析监控。
通过命令行分析 Fabric 数据仓库性能,定位慢查询与资源压力并给出优化建议。
通过命令行对 Fabric 仓库与湖仓数据执行只读 T-SQL 查询、探查与导出。
通过命令行对 Fabric 仓库与 Lakehouse 执行只读 T-SQL 查询、探查与导出数据。
通过命令行执行 Fabric 数仓与 SQL 端点的 T-SQL 编写、装载和架构变更操作。
通过命令行执行 Fabric 数仓与 SQL 端点的 T-SQL 编写、装载和变更操作。
通过命令行执行 Fabric 数仓与 SQL 端点的 T-SQL 编写、装载和变更操作。