SQL Server Guides
SQL Server
Azure SQL Database
Azure SQL Data Warehouse
Parallel Data Warehouse
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
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