Storage engine architecture and I/O

internals and architecture

Analytics Platform System (PDW)

SQL database in Microsoft

Fabric

The following guides are available. They discuss general concepts and apply to all versions of

, unless stated otherwise in the respective guide.

Concurrency, locking, and contention

Storage engine architecture and I/O

Query execution and optimization

Memory, threads, and internal scheduling

High availability, migration, and validation

Connectivity and authentication

Use these guides to understand how SQL Server manages concurrent access to data and

internal structures, and how to diagnose contention-related issues.

Description

to preserve transaction integrity.

efficiently control transactions.

Deep dive on Database Engine deadlocks that competing locks cause.

Explains how deadlocks form and how SQL Server detects and breaks

them.

contention on SQL Server

contention) in high-concurrency SQL Server workloads.

Diagnose and resolve

spinlock contention on SQL

Server

In-depth guide on identifying and resolving spinlock contention in high-

concurrency SQL Server workloads.

ﾉ