PerformanceMonitor

Overview

PerformanceMonitor is a comprehensive SQL Server monitoring solution that provides both a full edition (database-based) and a lite edition (desktop application). It features 32+ specialized T-SQL collectors, real-time alerts, graphical plan viewer, and an integrated MCP server exposing 51-63 read-only tools for AI analysis. The tool supports SQL Server 2016-2025, Azure SQL, and AWS RDS, with all data stored locally - no telemetry or cloud dependencies.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• get_server_health

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

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

  Identify the top wait types currently affecting server performance

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

  Analyze slow or problematic queries with execution plans

  Try:Show me the slowest queries on the serverTry:Analyze this query plan for bottlenecks
• check_blocking_chains

  Identify current blocking chains between sessions

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

  Analyze recent deadlock events and their causes

  Try:Show me recent deadlocks and their causesTry:What resources are involved in deadlocks?
• get_memory_grant_stats

  Check memory grant statistics for queries

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

  Analyze file I/O performance and bottlenecks

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

  Monitor tempdb space usage and potential issues

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

  Retrieve performance counters for the server

  Try:Show me CPU performance countersTry:Get memory-related performance metrics
• analyze_query_store

  Analyze query store data for query performance trends

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

  Analyze SQL Agent job execution performance

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

  Get current database size statistics and growth trends

  Try:Show me database sizes and growth ratesTry:Which databases are growing fastest?

Note: 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

Comparable tools

Installation

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

FAQ

What SQL Server versions are supported?

SQL Server 2016-2025, Azure SQL Managed Instance, AWS RDS for SQL Server, and Azure SQL Database (Lite edition only).

Does the MCP server require special permissions?

The MCP server runs with the same permissions as the monitoring tools. Lite edition requires VIEW SERVER STATE. Full edition requires SQL Agent permissions.

Compare PerformanceMonitor with