skills.rest
chrishuffman5
chrishuffman5COMMUNITY
Explore all skills by this author →
GitHub

sqlserver-monitoring

Monitor and diagnose SQL Server performance using DMVs, Extended Events, and Query Store.

Updated May 27, 2026
Search Tags:#diagnostics#performance monitoring#sql server#wait statistics#extended events
One-click install
npx skills add https://github.com/chrishuffman5/sqlserver --skill sqlserver-monitoring
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlserver-monitoring
Source: https://github.com/chrishuffman5/sqlserver/tree/main/skills/sqlserver-monitoring
Command: npx skills add https://github.com/chrishuffman5/sqlserver --skill sqlserver-monitoring

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides comprehensive performance monitoring and diagnostics for SQL Server, helping you identify and resolve issues efficiently.

Core Features & Use Cases

  • Performance Monitoring: Track and analyze wait statistics, DMVs, Query Store, Extended Events, and performance counters.
  • Diagnostics: Diagnose CPU, I/O, memory, and locking issues with detailed analysis and step-by-step guidance.
  • Use Case: If you're experiencing slow performance on a SQL Server instance, this Skill can help you identify the root cause, whether it's a slow query, blocking, or resource contention.

Quick Start

Use the sqlserver-monitoring skill to analyze the performance of the current SQL Server instance.

Frequently Asked Questions about sqlserver-monitoring

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I diagnose SQL Server slow performance and identify the root cause?▼

Diagnose SQL Server slow performance by analyzing wait statistics, DMVs, and Query Store to identify root causes like slow queries, blocking, or resource contention. It provides detailed analysis and step-by-step guidance to resolve issues efficiently.

Can I monitor SQL Server performance on Linux and containers?▼

Yes, you can monitor SQL Server performance on Linux and containers. The monitoring capabilities support SQL Server 2016-2025 across Windows, Linux, and containerized environments, tracking CPU, I/O, memory, and locking issues.

What's the best way to track wait statistics and resource contention in SQL Server?▼

Track wait statistics and resource contention using SQL Server DMVs, Extended Events, and performance counters. This approach focuses on analyzing CPU, I/O, memory, and locking to pinpoint exact performance bottlenecks on the instance.

Do I need a specific SQL Server version to use Extended Events and Query Store for diagnostics?▼

Yes, you need SQL Server 2016-2025 to use Extended Events and Query Store for diagnostics. The Skill requires these versions to properly monitor and analyze performance counters, wait statistics, and resource contention.

How do I find blocking queries causing CPU and I/O bottlenecks in SQL Server?▼

Find blocking queries causing CPU and I/O bottlenecks by querying dynamic management views and Query Store. This isolates specific resource contention issues, providing detailed analysis for locking problems and slow queries.

Related Skills

Explore More Software Engineering Skills→
chrishuffman5chrishuffman5

sqlserver-engineering

Analyze SQL Server execution plans and optimize indexes for query performance.

Community
Advanced
VXerysVXerys

database-optimizer

Analyze slow PostgreSQL and MySQL queries and generate index strategies.

Community
Advanced
a53alia53ali

performance-optimization

Profile CPU, memory, I/O, network, and database usage to identify performance bottlenecks.

Community
Advanced
interflownexinterflownex
2

cloud-sql-postgres-health

Diagnose query bottlenecks and resource constraints in Google Cloud SQL for PostgreSQL instances.

Community
Advanced