PerformanceStudio

概述

Performance Studio 是一个全面的 SQL Server 执行计划分析器，结合了跨平台 GUI 和 CLI 工具，并内置 MCP 服务器用于 AI 辅助计划审查。它可以解析 .sqlplan XML 文件，识别缺失索引、估计不匹配和昂贵操作符等性能问题，并提供可操作的警告。该应用程序支持直接连接到 SQL Server 实例、批量处理查询和详细的计划比较。MCP 集成使 AI 模型能够无缝分析加载的计划、识别警告、建议索引和比较计划。

试试问 AI

装完之后，这里有 3 个你可以让 AI 做的事：

• analyze_sqlplan

  Analyze SQL Server execution plans from .sqlplan files

  试试:Analyze this SQL execution plan for performance issues试试:What warnings does this query plan have?试试:Find missing indexes in this plan file
• analyze_live_plan

  Capture and analyze execution plans from a live SQL Server

  试试:Run this query on SQL Server and analyze its execution plan试试:Capture the estimated execution plan for a query without running it试试:Analyze the plan for this query against my SQL Server instance
• compare_plans

  Compare two SQL Server execution plans side by side

  试试:Compare these two execution plans and show the differences试试:What changed between these two query plans?试试:Show me the performance differences between these plans
• get_query_store

  Fetch and analyze query store data from SQL Server

  试试:Get the top CPU-consuming queries from query store试试:Analyze the most executed queries in my database试试:Fetch queries with high duration from query store
• get_warnings

  Extract warnings from a SQL execution plan

  试试:What warnings are in this execution plan?试试:Find all critical issues in this query plan试试:Show me the performance warnings for this plan
• get_missing_indexes

  Extract missing index suggestions from SQL execution plans

  试试:What indexes are missing from this query plan?试试:Show me the recommended indexes for this plan试试:Generate CREATE INDEX statements for missing indexes
• analyze_operator

  Analyze a specific operator in a SQL execution plan

  试试:Analyze this specific operator in the plan试试:What does this sort operator in the plan do?试试:Explain the parallelism operator in this query plan

可对比工具

安装

git clone https://github.com/erikdarlingdata/PerformanceStudio.git
cd PerformanceStudio
dotnet build

{
  "mcpServers": {
    "performance-studio": {
      "command": "dotnet",
      "args": ["run", "--project", "src/PlanViewer.Cli", "--", "mcp"]
    }
  }
}

PerformanceStudio 对比