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

sqlserver-infrastructure

Configure SQL Server memory, CPU, NUMA, tempdb, storage, and network settings.

Updated May 27, 2026
Search Tags:#configuration#memory#infrastructure#sql server#cpu
One-click install
npx skills add https://github.com/chrishuffman5/sqlserver --skill sqlserver-infrastructure
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlserver-infrastructure
Source: https://github.com/chrishuffman5/sqlserver/tree/main/skills/sqlserver-infrastructure
Command: npx skills add https://github.com/chrishuffman5/sqlserver --skill sqlserver-infrastructure

SYSTEM DOCUMENTATION & REQUIREMENTS

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

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.

Frequently Asked Questions about sqlserver-infrastructure

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

FAQPage Schema
How do I configure SQL Server infrastructure settings for memory and CPU?▼

Optimize tempdb for SQL Server by configuring data file sizing, autogrowth settings, and memory-optimized metadata. This Skill streamlines tempdb management to ensure efficient data processing and prevent file allocation bottlenecks.

What is the best way to audit SQL Server instance configuration against recommended baselines?▼

Auditing SQL Server instance configuration involves running an audit script that checks current settings against recommended baselines. This Skill provides a quick start script to evaluate your memory, CPU, and storage configurations for optimal performance.

Can I use this to configure storage layout and network protocols for SQL Server?▼

Yes, you can configure storage layout by separating data, log, tempdb, and backup volumes, and manage network protocols including TCP/IP, Named Pipes, and Shared Memory. This Skill applies these infrastructure settings across various SQL Server versions.

Does this SQL Server optimization require external packages or dependencies?▼

No, this SQL Server optimization requires no external packages or dependencies. It relies on built-in dynamic management views like sys.dm_os_sys_memory, sys.dm_os_schedulers, and sys.dm_io_virtual_file_stats to analyze and apply infrastructure configurations.

How do I configure soft-NUMA and scheduler affinity in SQL Server?▼

Configure soft-NUMA and scheduler affinity in SQL Server by applying specific CPU and NUMA node settings. This Skill utilizes sys.dm_os_nodes and sys.dm_os_schedulers to optimize your instance's processor resource distribution.

Related Skills

Explore More Software Engineering Skills→
TheBushidoCollectiveTheBushidoCollective
187

performance-optimization

Profile bottlenecks and apply validated optimizations with repeatable metrics.

Official
Advanced
xotongxotong

V3 Performance Optimization

Benchmark and optimize Claude-flow v3 memory, CPU, and swarm coordination.

Community
Advanced
chrishuffman5chrishuffman5

sqlserver-ha-clustering

Automate SQL Server high availability and clustering configurations.

Community
Advanced
vertivolatamvertivolatam
1

OVHCloud Backend Deployment

Deploy Flutter backends on OVHCloud with managed Kubernetes and PostgreSQL.

Official
Intermediate