SQL Server › SQL Server Architecture & Editions

How would you plan a hardware and configuration strategy for a new SQL Server installation supporting a large, performance critical application?

Advanced

Answer

You would carefully size available memory to support a sufficiently large buffer pool for your expected data volume, choose fast storage such as solid state drives especially for tempdb and transaction log files, properly configure the maximum degree of parallelism setting based on your specific workload type, and separate data, log, and tempdb files across different physical storage where possible to reduce contention.
-- Example configuration considerations
EXEC sp_configure 'max degree of parallelism', 4;
RECONFIGURE;
Real-world example A team planning infrastructure for a new high transaction volume application carefully separates their data files, transaction log, and tempdb onto different fast storage volumes, while tuning the max degree of parallelism setting specifically for their transactional workload pattern.

Common follow-ups: How does the max degree of parallelism setting affect different types of workloads differently?;What storage configuration is generally recommended for the transaction log file specifically?