Index

A

ABORT_AFTER_WAIT option for low-priority locks
ACID
Allocation maps
Allocation map scan, 14
Allocation unit
ALTER DATABASE SET ALLOW_SNAPSHOT_ISOLATION statement
ALTER DATABASE SET READ_COMMITTED_SNAPSHOT statement
ALTER INDEX REBUILD statement
ALTER INDEX REORGANIZE statement in columnstore indexes
ALTER TABLE REBUILD statement
ALTER TABLE SET LOCK_ESCALATION statement
AlwaysOn Availability Groups
Application lock
Archival compression in columnstore indexes
Asynchronous commit in AlwaysOn Availability Groups
Atomicity, transaction property
Autocommitted transactions

B

Batch mode execution
BEGIN TRAN statement
BeginTs timestamp
Blocked process report
blocked_process_report Extended Event, see Extended events
Blocked process threshold configuration option
Blocking ...

Get Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.