# SQL Server Performance Monitor

> Use this tool when you need to monitor and diagnose performance issues in SQL Server instances, solving problems such as CPU bottlenecks, memory pressure, and I/O issues. It takes SQL Server instance connections as input and outputs detailed metrics and alerts, stored locally in DuckDB with Parquet archival. Ideal for use in environments with SQL Server 2016-2025, Azure SQL MI, AWS RDS, and Azure SQL Database, where remote monitoring and troubleshooting are required.

Canonical page: https://skillsregistry.net/skills/erikdarlingdata-sql-server-performance-monitor  
JSON: https://api.skillsregistry.net/v1/skills/erikdarlingdata-sql-server-performance-monitor

## Description

A free, open-source SQL Server performance monitoring tool (Lite edition) that remotely queries DMVs without installing anything on the target server. Stores collected metrics locally in DuckDB with automatic Parquet archival. Includes an embedded MCP server exposing tools for diagnosing CPU issues, wait statistics, blocking chains, query performance, memory pressure, I/O bottlenecks, TempDB contention, SQL Agent job health, and alerting. Supports SQL Server 2016-2025, Azure SQL MI, AWS RDS, and Azure SQL Database.

## Trust

- **Trust score (0–1):** 0.50
- **Verification tier:** unverified

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-05-27

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/erikdarlingdata-sql-server-performance-monitor)
- **Repository:** <https://github.com/erikdarlingdata/performancemonitor/tree/HEAD/Lite>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "erikdarlingdata-sql-server-performance-monitor"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/erikdarlingdata-sql-server-performance-monitor` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/erikdarlingdata-sql-server-performance-monitor/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt