Performance Monitor

概要

Performance Monitor offers comprehensive, open-source performance monitoring for SQL Server environments, including cloud-managed instances. It aims to provide deep operational insights without the complexity of typical enterprise solutions, catering to DBAs, consultants, and developers. Available in two distinct editions—a server-installed Full Edition for 24/7 production monitoring and a standalone Lite Edition for remote troubleshooting and Azure SQL Database—it ensures flexibility and adaptability to various deployment and usage scenarios, with robust data collection, alerting capabilities, and AI integration via an optional MCP server.

主な機能

• 111 GitHub stars
• Two Editions: Full (server-installed, 30 collectors) and Lite (standalone, DuckDB, 20 collectors)
• Configurable data retention, alerts (blocking, deadlocks, CPU), and easy installation via CLI or GUI
• Built-in MCP server for AI-powered analysis and LLM integration
• Comprehensive dashboards for resource overview, performance trends, locking, and system events
• Support for SQL Server 2016-2025, Azure SQL Managed Instance, AWS RDS for SQL Server, and Azure SQL Database (Lite only)

ユースケース

• Quick triage and remote troubleshooting of SQL Server performance issues, especially on Azure SQL Database or locked-down servers.
• 24/7 monitoring and long-term baselining of SQL Server production environments.
• Consultants needing a portable, standalone tool for client environments without requiring server-side installations.