Skills
.Work. You
Rest

sqlserver-infrastructure

Community

Optimize and configure SQL Server infrastructure efficiently.

Software Engineering#configuration#memory#infrastructure#sql server#cpu
Authorchrishuffman5
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill streamlines the configuration and optimization of SQL Server infrastructure, addressing memory, CPU, NUMA, tempdb, storage, and network settings.

Core Features & Use Cases

  • Memory Configuration: Set max server memory, min server memory, and related parameters.
  • CPU & NUMA: Configure MAXDOP, cost threshold, affinity, and soft-NUMA settings.
  • tempdb Management: Optimize tempdb file size, growth, and memory-optimized metadata.
  • Storage Layout: Ensure proper separation of data, log, tempdb, and backup volumes.
  • Network Configuration: Configure TCP/IP, Named Pipes, and Shared Memory protocols.
  • Use Case: A DBA can use this Skill to configure a new SQL Server instance for optimal performance, ensuring that memory and CPU resources are allocated appropriately and tempdb is configured for efficient data processing.

Quick Start

Run the scripts/01-instance-config-audit.sql script to audit your SQL Server instance configuration against recommended baselines.

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-infrastructure
Download link: https://github.com/chrishuffman5/sqlserver/archive/main.zip#sqlserver-infrastructure

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 620,000+ vetted skills library on demand.