PerformanceMonitor

概述

PerformanceMonitor 是一个全面的 SQL Server 监控解决方案，提供完整版（基于数据库）和轻量版（桌面应用程序）。它包含 32+ 个专门的 T-SQL 收集器、实时警报、图形化计划查看器，以及集成的 MCP 服务器，提供 51-63 个只读工具用于 AI 分析。该工具支持 SQL Server 2016-2025、Azure SQL 和 AWS RDS，所有数据本地存储，遥测和云依赖为零。

试试问 AI

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

• get_server_health

  Get overall server health status with green/yellow/red indicators

  试试:What's the overall health status of my SQL Server?试试:Show me server health cards
• get_top_wait_types

  Identify the top wait types currently affecting server performance

  试试:What are the top wait types on my server?试试:Show me current wait stats
• analyze_query_performance

  Analyze slow or problematic queries with execution plans

  试试:Show me the slowest queries on the server试试:Analyze this query plan for bottlenecks
• check_blocking_chains

  Identify current blocking chains between sessions

  试试:Are there any blocking sessions right now?试试:Show me current blocking chains
• analyze_deadlocks

  Analyze recent deadlock events and their causes

  试试:Show me recent deadlocks and their causes试试:What resources are involved in deadlocks?
• get_memory_grant_stats

  Check memory grant statistics for queries

  试试:Which queries are requesting the most memory?试试:Show me memory grant issues
• analyze_file_io

  Analyze file I/O performance and bottlenecks

  试试:Which files have the highest I/O wait time?试试:Show me file I/O statistics
• check_tempdb_usage

  Monitor tempdb space usage and potential issues

  试试:How much space is tempdb using?试试:Are there tempdb contention issues?
• get_performance_counters

  Retrieve performance counters for the server

  试试:Show me CPU performance counters试试:Get memory-related performance metrics
• analyze_query_store

  Analyze query store data for query performance trends

  试试:Show me query store data for the last hour试试:Which queries regressed in performance?
• check_job_performance

  Analyze SQL Agent job execution performance

  试试:Show me job execution times and failures试试:Which jobs are taking the longest to run?
• get_database_sizes

  Get current database size statistics and growth trends

  试试:Show me database sizes and growth rates试试:Which databases are growing fastest?

说明：Tools are mentioned in the 'Built-in MCP server with 51-63 read-only tools for AI analysis' section, though specific tool names are not explicitly listed. The tool names and descriptions are inferred from the collectors mentioned in the doc

可对比工具

安装

{
  "mcpServers": {
    "performance-monitor": {
      "command": "PerformanceMonitorLite.exe",
      "args": ["--mcp"]
    }
  }
}

FAQ

支持哪些 SQL Server 版本？

支持 SQL Server 2016-2025、Azure SQL 托管实例、AWS RDS for SQL Server 以及 Azure SQL 数据库（仅限轻量版）。

MCP 服务器需要特殊权限吗？

MCP 服务器与监控工具使用相同的权限。轻量版需要 VIEW SERVER STATE 权限，完整版需要 SQL Agent 权限。

PerformanceMonitor 对比