Skills
.Work. You
Rest

sqlserver-index-management

Community

Optimize SQL Server index performance.

Software Engineering#performance tuning#sql server#index management#database optimization#fragmentation#t-sql
Authorrudi-bruchez
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill addresses slow database query performance caused by inefficient or missing indexes, and helps maintain optimal index health in SQL Server.

Core Features & Use Cases

  • Fragmentation Analysis: Identifies and provides solutions for index fragmentation.
  • Missing Index Detection: Recommends and helps create indexes that the optimizer suggests are missing.
  • Unused Index Identification: Flags indexes that are not being used, saving resources.
  • Maintenance Strategy: Offers scripts for both reorganizing and rebuilding indexes based on fragmentation levels.
  • Use Case: A critical application is experiencing slow response times. You suspect index issues. This Skill can analyze fragmentation, identify missing indexes that could speed up specific queries, and suggest or execute maintenance tasks like rebuilding or reorganizing indexes.

Quick Start

Analyze index fragmentation for all indexes in the current database.

Dependency Matrix

Required Modules

None required

Components

scriptsreferences

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: sqlserver-index-management
Download link: https://github.com/rudi-bruchez/dba-skills/archive/main.zip#sqlserver-index-management

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.