SQL Server Guides

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database YesAzure SQL Managed Instance yesAzure Synapse Analytics yesAnalytics Platform System (PDW)

The following guides are available. They discuss general concepts and apply to all versions of SQL Server, unless stated otherwise in the respective guide.

Always On Availability Groups Troubleshooting and Monitoring Guide
Diagnose and resolve latch contention on SQL Server
Diagnose and resolve spinlock contention on SQL Server
Index Architecture and Design Guide
Memory Management Architecture Guide
Pages and Extents Architecture Guide
Post-migration Validation and Optimization Guide
Query Processing Architecture Guide
SQL Server Transaction Locking and Row Versioning Guide
SQL Server Transaction Log Architecture and Management Guide
Thread and Task Architecture Guide