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

Ready to run

npx skills add https://github.com/chrishuffman5/sqlserver --skill sqlserver-infrastructure

💬 Prompt for ChatGPT / Claude Chat▼

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.